Circular reference/SumProduct

[Guest]

I am getting a circular reference message. The reference is no wto every
cell I have that contains a formula (C9 contains =Sum(c4:c8) and that gets
referenced as does every Sumproduct. for example
=SUMPRODUCT(--($I$2:$I$2495="yes")*($A$2:$A$2495="James")*($M$2:$M$2495)*($H$2:$H$2495>=DATE(2004,11,8))*($H$2:$H$2495<=DATE(2004,11,14)))
There are many variations of this for different variables which all once
worked but are now all referenced as circular. When I delete one it just
references the next. Do I have to start all over? There are 90 Sumproduct
variations here.

Thanks.

 

[JulieD]

Hi

if you want to zip up the file and send it directly to me i'll be happy to
look at it for you.
julied_ng at hcts dot net dot au

Cheers
JulieD