So what was wrong with Peo's suggestion?

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)



"delete automatically" wrote
in message ...

ok heres what I have.
in cell D6 I have formula of =AVERAGE(D7:D10) which its at #div/0!
in cell D11 = AVERAGE(D12:D15) which its at 85
in cell D16 =AVERAGE(D17:D210) which its at 50

in cell D3 I just want the average of cell D6,D11,and D16
is this possible and how?



"Peo Sjoblom" wrote:

=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