# Thread: Circular Referance

1. Registered User
Join Date
Jan 2004
Posts
3

## Unanswered: Circular Referance

Hi, Can someone help me!!!

I am trying to get the Formula below to work:

=SUM(ifB5:B51=3,D52+1)

When ever i input this Excel says that it is a Circular Referance, I cant see what wrong with it and i dont know how to correct it can anyone help me!!!!

2. Registered User
Join Date
Jan 2004
Location
The Netherlands
Posts
421
Your formula is totaly wrong....
Either: Simif(criteriarange;Critiria;sumrange)
Or: Sum(sumrange)
Or: If(Criteria;true;false)

What is it your trying to do?

Regards

3. Registered User
Join Date
Jan 2004
Posts
3
I am bit of a novice when i comes to Excel!!!

This is what i'm trying to do, If Any of Cells from B5 to b51 = 3 then add 1 to cell C52

Matt

4. Registered User
Join Date
Jan 2004
Posts
3
Ok Ive worked out where i was going wrong with the syntrax of the formula, and this is what ive got so far:

=if(B5:B51=3,1)

But Excel doesnt seem to like the B5:B51 part of the Formula, and also at the moment the formula (if it works) will just change the cell value to 1 and not Add 1 to it, +1 doesnt work? What would be the correct way to put it?

5. Registered User
Join Date
Jan 2004
Location
The Netherlands
Posts
421
what your trying to do is count the number of 3's in the B column?

If so: =CountIf(B:B,3)

You cannot tell excel to add one to another cell, you must do that in VBA code not a formula. But this formula, i think, is what you are looking for. (paste it on your sheet somewhere to see if it works)

Regards

6. Registered User
Join Date
Oct 2003
Posts
1,091
Where are you putting this formula?

You have placed two difference references for the result: D52 in OP, and then C52 in your last post.

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•