Hey guys I have already gone nuts
I want to calculate the average of eight cells in a column. The value of each of the cells can be either "blank", "zero" or a number based on a function calculating from a different cell.

Details: I have the value of G28 as =IF(E28>VALUE(R18),"25","0") the same applies thru E28:E35 for a total of 8 entries. However sometimes there are only 6 entries so E34 and E35 are blank but the Average on G36 returns the error #DIV/0!

how can I make the Average function ignore the blank cells?

I am already reliefed spiling myself out. hopefully someone an help me.

until then i aint sleeping guys