"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
---