I'm struggling to figure out an if/then formula that will calculate the average of the previous cells and ignore any cells that have the value of "0." I only want an average of any cell that has a number <0. How do I put this into a formula?
I'm struggling to figure out an if/then formula that will calculate the average of the previous cells and ignore any cells that have the value of "0." I only want an average of any cell that has a number <0. How do I put this into a formula?
Typically, use =SUM(the range)/COUNTIF(the range,"<>0")
Regards, TMS
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Use AVERAGEIF, like this:
=AVERAGEIF(A1:A10,"<>0")
Hope this helps.
Pete
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks