I don't understand what you mean, the formula works fine for me are you
entering it with ctrl + shift & enter? The only way I can get a div error is
if there are only text, zeros or blanks in column O.. You might also want to
change the size of your ranges unless you really have over 65000 entries in
your columns

Btw, you have too many parentheses

=AVERAGE(IF(D3:D1000="2A",IF(K3:K1000=38,IF(O3:O10 00<0,O3:O1000))))

--


Regards,


Peo Sjoblom




"Rebekah" wrote in message
...
I have multiple columns of data in another sheet and am using this formula
(entered as an array) to provide an average based on conditions, one
column
reads "2a", and another reads "38" etc.

i thought that by by entering the IF formula to include "<0", this would
count all the data and return a zero value for a blank or zero value. (I
certainly hope this is making sense to somebody!!!)

=AVERAGE(IF('Summary Days'!$D$3:$D$65536="2A",(IF('Summary
Days'!$K$3:$K$65536=38,(IF('Summary Days'!$O$3:$O$1500<"0",'Summary
Days'!$O$3:$O$1500))))))

This formula works if in all columns there is a value above zero, but
returns "#DIV/0!" if not. This would be ok if my table wasn't presenting
data for a fixed period....
Please help!!!