Circular reference/SumProduct
 

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.

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

"wal50" wrote in message
...
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.