At one stage you say average only if there is a number in the cell, but
later you say only if the number is greater than zero.

The AVERAGE function will only take account of cells with numbers in, and
will ignore empty cells or those with text.
If you want to ignore cells where the number is <=0, then try
=AVERAGE(IF(A1:A40,A1:A4,"")) as an array formula (Control Shift Enter).
--
David Biddulph

"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