Maybe this...........

=SUM(I15:AH15)/COUNTIF(I15:AH15,"0")

Vaya con Dios,
Chuck, CABGx3


"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.