Countif problems

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 
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
 
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.
 
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?
 
Hi

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

Cheers
JulieD
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Countifs bites again 4
Countif 4
COUNTIFS AND CRITERIA 2
Excel Formula - Count Dates from another Sheet 8
countifs Function not giving desired result with date criteria 2
COUNTIF with Dates 3
error with countif formula on when adding linked spreadsheets 0
Mutiple COUNTIF or equivalent. 8

Back
Top