Average function exluding zeroes

[ajpowers]

I'm trying to get an average number using an array formula that exlude
zeroes in the data range. Tha following is the formula Microsoft Hel
game me but I get a VALUE error back:

=average(if(a2:a7<>0,a2:a7,""))

Thank

 

[Bernie Deitrick]

AJ,

That should work - though it may give an error if you haven't entered it
using Ctrl-Shift-Enter and the cell on the same row as the formula is blank,
or if all the values are strings.

HTH,
Bernie
MS Excel MVP

 

[ajpowers]

Bernie - That worked, thank you very much