#DIV/0! in the array function
 

Hello,

I keep on receiving the #DIV/0! error in the following formula (BTW, Bob
Phillips, thanks again for the hint):

{=COVAR(IF((A2:A10--"01/01/2004")*(A2:A10<--"31/10/2004"),B2:B10),IF((A2:A10--"01/01/2004")*(A2:A10<--"31/10/2004"),C2:C10)}

the cells A2:A10 contain dates and B2:C10 contain numbers (some of them are
0, but it isn't a problem). The problem is that I need to calculate the
covarience over a specific range in the bigger table, so I have to use an
array formula. Yet, whatever values I have, it gives me division by zero
error.

Is there a way I can fix this? or how can I trace an error?

So far I realised that condition I have gives my FALSE results in any case,
however this range does exist.

Please help! My thesis deadline is approaching ))

Thanks in advance, Sergiy

#DIV/0! in the array function
 

Sergiy,

Send me the workbook and I will take a look.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Sergun" wrote in message
...
Hello,

I keep on receiving the #DIV/0! error in the following formula (BTW, Bob
Phillips, thanks again for the hint):


{=COVAR(IF((A2:A10--"01/01/2004")*(A2:A10<--"31/10/2004"),B2:B10),IF((A2:A1
0--"01/01/2004")*(A2:A10<--"31/10/2004"),C2:C10)}

the cells A2:A10 contain dates and B2:C10 contain numbers (some of them
are
0, but it isn't a problem). The problem is that I need to calculate the
covarience over a specific range in the bigger table, so I have to use an
array formula. Yet, whatever values I have, it gives me division by zero
error.

Is there a way I can fix this? or how can I trace an error?

So far I realised that condition I have gives my FALSE results in any
case,
however this range does exist.

Please help! My thesis deadline is approaching ))

Thanks in advance, Sergiy