sumif formula in Excel 2003

[Ellen]

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.

 

[Ellen]

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?

 

[Bob Phillips]

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

--
---
HTH

Bob


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

 

[Max]

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.

---

 

[Matt Richardson]

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

--
---
HTH

Bob

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

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