How do I set an average to not count blank cells as zeros?
What is in cell I10?
Tyro
"athenia_1999" wrote in message
...
I am trying to use Excel for a grade book, but can not figure out how to
get
the average function to not count blank cells as zeros. The following
function is in the Averages column:
=(IF(SUM(I15:AH15),ROUND(SUM(I15:AH15)/$I$10,2),""))
the average is displayed as a percent.
|