Hi all,
Does anyone how to make an average but to exclude any cells that include a zero please?
Thanks,
Hi all,
Does anyone how to make an average but to exclude any cells that include a zero please?
Thanks,
Try this.
Change the range as required.
=AVERAGEIF(A1:A4,"<>0",A1:A4)
Last edited by NeedForExcel; 05-03-2016 at 05:08 AM. Reason: Minor Mistake Corrected (Realized after seeing BadlySpelledBuoy's formula)
Cheers!
Deep Dave
Formula:Please Login or Register to view this content.
BSB
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks