Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Circular reference | Excel Discussion (Misc queries) | |||
Why do multiple circular references affect each other in a worksh. | Excel Discussion (Misc queries) | |||
Help getting around circular referencing | Excel Discussion (Misc queries) | |||
Circular functions | Excel Worksheet Functions | |||
Circular reference | Excel Worksheet Functions |