Countif problems

[Sony]

I am entering the following =COUNTIF(AC5:AI150,"True"). Basically, what
happens now is Excel is creating a Circular referance, I had this working on
another spreadsheet from last year (2004) but everytime I try to on the
spreadsheet for 2005 it creates this. Any suggestions?

My goal is to count any cells with True in it, which are all based on
different scenarios from another sheet within the workbook. Thanks in
advance for your help!

 

[JulieD]

Hi Sony

if they're on another sheet you need to include the sheet name
=COUNTIF('Other Sheet'!AC5:AI150,"True")

if this isn't the problem what is the cell reference that you're putting the
formula in?

Cheers
JulieD

 

[Huw]

Only reason I can think of that it would come up with a circular reference is
that the cell with the formula, is inside the range AC5:AI150.

 

[Sony]

Sorry I did not include that part. The cell with the formula is B18.

Could it be because the formulas within AC5:AI150 are basing "True" from
another worksheet & that includes B18?

 

[JulieD]

Hi

if it's the same B18 then yes, you have a circular reference problem ...

Cheers
JulieD

 

[Sony]

Julie,

Basically what I am doing is AC5:AI150 on Sheet 3 are using formulas based
on information from another sheet (Sheet 1) within the same workbook. Based
on the return value True or False will be displayed in these cells (AC5:AI150

 

[Aladin Akyurek]

Try:

=COUNTIF(AC5:AI150,TRUE)