Results 1 to 6 of 6
  1. #1
    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. #2
    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. #3
    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. #4
    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. #5
    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. #6
    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.
    old, slow, and confused
    but at least I'm inconsistent!

    Rich
    (retired Excel 2003 user, 3/28/2008)

    How to ask a question on forums

Posting Permissions

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