Thay's because it's an array formula. Type the formula in the cell then
commit it by pressing

Ctrl+Shift+Enter

If you've done it corrrectly then Excel will put curly brackets around the
formula.

Mike

"GeoffWhite18" wrote:

Ok so I tried that and end up with a #VALUE! error. What I'm trying to do is
find the average Through cells G2:G50 and ignor any values less than 1.
=AVERAGE(IF(G2:G50<0,G2:G50))

" wrote:

On Feb 7, 9:06 am, Cliff wrote:
=AVERAGE(IF(B5:B17<0,B5:B17)) & enter this as an array formula via
Ctrl+Shift+Enter

or in Excel 2007

=AVERAGEIF(B5:B17,"<0")

Thanks Cliff, that worked perfectly!