sumif formula in Excel 2003

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Ellen - 01 Feb 2008 16:40 GMT

I opened a spreadsheet that I have not used since I changed to Excel 2003.
When I try to copy a "sumif" created prior to Excel 2003, the formula is
there but it does not calculate correctly. Also, when I "edit" the formula,
I get the green triangle in the upper left corner of the cell.

Reply to this Message

Ellen - 01 Feb 2008 17:02 GMT

I found that if I "edit," and then pres shift control and enter at the same
time, that my formula will then calculate correctly. Is there something else
I could do where I don't have to do this?

> I opened a spreadsheet that I have not used since I changed to Excel 2003.
> When I try to copy a "sumif" created prior to Excel 2003, the formula is
> there but it does not calculate correctly. Also, when I "edit" the formula,
> I get the green triangle in the upper left corner of the cell.

Reply to this Message

Bob Phillips - 01 Feb 2008 18:47 GMT

Maybe you have manual calculation set, Tools>Options>Calculation

Signature

---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

>I found that if I "edit," and then pres shift control and enter at the same
> time, that my formula will then calculate correctly. Is there something
[quoted text clipped - 7 lines]
>> formula,
>> I get the green triangle in the upper left corner of the cell.

Reply to this Message

Matt Richardson - 12 Feb 2008 14:43 GMT

> Maybe you have manual calculation set, Tools>Options>Calculation
>
[quoted text clipped - 17 lines]
> >> formula,
> >> I get the green triangle in the upper left corner of the cell.

What is your formula? If it only works correctly with CSE then it
would seem it is an array formula. Can you show us the formula in
question?

Kind regards,
Matt Richardson
http://teachr.blogspot.com

Reply to this Message

Max - 01 Feb 2008 18:50 GMT

> I found that if I "edit," and then pres shift control and enter at the same
> time, that my formula will then calculate correctly.
> Is there something else I could do where I don't have to do this?

Pressing CTRL+SHIFT+ENTER (CSE) is the correct and only way to
"enter"/confirm an array formula, which was probably what your formula was,
albeit you didn't post your formula.

If the CSE is correctly done, you should see Excel insert curly braces: { }
around the formula, in the formula bar. Sight this as a visual check to
ensure that the formula is correctly array-entered.

Signature

Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

Reply to this Message