Hi Connie

the formula is an array formula and should be entered or edited using
Control+****+Enter, (CSE) not just Enter
When you use CSE, Excel will place curly braces around the formula { }. Do
not enter the Curly braces yourself.

One sheet has the array entered formula, the other doesn't

--
Regards
Roger Govier

"Connie Martin" wrote in message
...
I have this formula in L20 that works one place and not the other:

=IF(F20=0,"",IF(F20=1,1,AVERAGE(IF(F15:F19<0,F15: F19))))

On one worksheet the number in F20 is 1, and it gives 1 in L20 with this
formula, but in another worksheet, the number is 11 in F20, and I get
#VALUE!
in L20.

What is the reason?

Connie