Need array formula to ignore zeroes

A

ajpowers

I've forgotten how to write a formula that will calculate the avg. of
range of cells, but will ignore the zeroes. What am I doing wrong?
The formula below is returning a True or False statement and I don'
want that. Thanks.

=IF(AVERAGE(AC5:AJ5)<=0,(AC5:AJ5)<>""
 
C

Chip Pearson

Try something like the following array formula:

=AVERAGE(IF(A1:A10<>0,A1:A10,FALSE))



--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
Top