Does Excel 2000 have AVERAGEIF?

[Vintage79]

Hi guys,

I have a simple problem. I want a formula to calculate the average in a column, but for it to disregard any cell that shows a zero. It's so simple that I decided to search rather than post - here is what I came up with:

=AVERAGE(IF(V6:V57,">0"))

Unfortunately this doesn't work for me - I get #VALUE! instead. I couldn't find the function in the help file so I think that my version must be too old. Is there a way around this? Perhaps combining AVERAGE with IF?

Thanks a lot!


Martin

 

[Matty]

Hi,

Try:

=AVERAGE(IF(V6:V57>0,V6:V57))

Which needs committing with Ctrl+Shift+Enter.

Matty

 

[Dave Patton]

Array enter the following with Ctrl+Shift+Enter not just enter

=AVERAGE(IF(V6:V57>0,V6:V57))

 

[Vintage79]

Thanks a lot guys - That works perfectly!!