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!!!!

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

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

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?

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

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.