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

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