=SUMIF(A1:A4,"0")/COUNTIF(A1:A4,"0")

or


=AVERAGE(IF(A1:A40,A1:A4))


the latter entered with ctrl + shift & enter


You might want to test for 0 in the cells because if all cells are zero it
will return a div error


=IF(COUNTIF(A1:A4,0)=4,0,rest of the formula





--


Regards,


Peo Sjoblom


"delete automatically" wrote
in message ...
I need a formula to average cells only if there is a number in a cell.
Example in cell A1, A2,A3 A4 they all have a formulasand all 4 cells say
0.00
in cell A5 i have =average(A1:A4)

So if I put 100 in cell A1 then my answer in cell A5 says 25

I Would like it to say 100
only average if the number is higher that 0.00

Thanks