COUNTIF problem with Circular Reference

[Mr.Ed Wz]

I have six identical workbooks, each contains 8 to 12 identical worksheets.
Only one worksheet will not execute the formula in E2. the value is always
0. Once I received a circular error report of $I$1, I really don’t know what
to do about it. I copied all the data to another worksheet and my problem
just follows it. Thanks and appreciation for reading my post..Ed


B1=COUNT(B5:B368) Counts the number of records
B2=B1-G3 Subtracts the work repaired

E1=COUNTIF(I:I,"NPF") Counts the repair codes
E2=COUNTIF(I:I,"SPLICE")
E3=COUNTIF(I:I,"DROP")


G1=COUNTIF(I:I,"HOUSE")
G2=COUNTIF(I:I,"ILLEGAL")
G3=K1+K2 provides the total number of repair codes

K1=SUM(E1:E3) adds subtotals
K2=G1+G2

 

[Charles Williams]

Hi Ed,

presumably Iteration is not switched on ...

Have you checked for any formulae in column I on the sheet that does not
work?
You could also try Ctrl/AltF9

regards
Charles
______________________
Decision Models
FastExcel Version 2 now available.
www.DecisionModels.com/FxlV2WhatsNew.htm

 

[HKBigB]

Based on your formula, I don't found any problem.

"Circular error" due to formula refers back to its own cell, eithe
directly or indirectly.

May be you forgot list out some formula in this forum, please tell u
more detail.

Thanks

 

[HKBigB]

Suppose when the "circular error" happened, Excel will show a pop-u
screen, then choose "OK", Circular Reference toolbar appears and i
will tell you where is the mistake you made.

If the Circular Reference toolbar not showup, move your mouse to th
blank area of Toolbars area ( upper part of your screen with so man
icons ), then right-click your mouse and then choose "Circula
Reference", you will see where is your error come from.

Good Luck

 

[Frank Kabel]

Hi
goto 'Tools - Options - calculation' and check if automatic calculation
is enabled.
Also try hitting CTRL+F9. does this change anything?

 

[Mr.Ed Wz]

Thanks everyone,

Iteration was not previously checked (now it is)
All formulae were listed
Cells I1-I3 are empty
Auto calculation selected
The only one time Circular Reference pointed to all foumulae in the 1st
three rows as listed.
Ctrl Alt F9 has no effect

that's all I know ...Ed