sumif formula in Excel 2003
 

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.

sumif formula in Excel 2003
 

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.

sumif formula in Excel 2003
 

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.

sumif formula in Excel 2003
 

"Ellen" wrote:
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.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

sumif formula in Excel 2003
 

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