On Feb 1, 6:47 pm, "Bob Phillips" wrote:
Maybe you have manual calculation set, ToolsOptionsCalculation

--
---
HTH

Bob

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

"Ellen" wrote in message

...

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?

"Ellen" wrote:

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.

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