Average function exluding zeroes

  • Thread starter Thread starter ajpowers
  • Start date Start date
A

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
 
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
 
Back
Top