How do I reference a cell from within a condition in Numbers?

Discussion in 'iPad Apps' started by jgoody10, May 23, 2012.

  1. macrumors newbie

    Joined:
    Jan 10, 2010
    #1
    I am trying to use the SUMIF function to sum values within an array IF corresponding values in the array are greater than a value in a corresponding cell. So:

    ___A____B____C
    5/23/12 1
    5/24/12 2 May 24, 2012
    5/25/12 3
    5/26/12 4

    Here is the formula I am trying to use:

    =SUMIF(A1:A4,">"C2,B1:B4)

    This gives me a syntax error. In Microsoft Excel I could get the result I want with the following formula:

    =SUMIF(A1:A4,">"&C2,B1:B4)

    You need that & to "build" a condition statement in Excel. But I don't even see the option to type in a & in a formula in Numbers.

    Is this possible in Numbers and if so, how?

    Thanks very much for any assistance.

     
  2. thread starter macrumors newbie

    Joined:
    Jan 10, 2010
    #2
    OK, I solved it. The formula DOES work if you include the & character in Numbers, and that character is in fact sitting right in front of you in the upper left part of the text input area--you just have to toggle the "operators" section of the input area once to get it. Sorry to bug everyone.
     

Share This Page