try the averageif function | Message 28 of 28 | TechRepublic

Discussion on:

Office Challenge: How can you get Excel to return an average that doesn't consider 0 values?

View entire thread

Message 28 of 28

Next »

0 Votes

+ -

try the averageif function

I use this all the time in my grade spreadsheets. I want to know the exam average without any "0"s (say if someone missed the exam for example). I type in "AVERAGEIF(A2;A25,"0").

Posted by esikorski@...

14th Feb 2012