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

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

  1. jgoody10 macrumors newbie

    Jan 10, 2010
    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:

    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:


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


    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. jgoody10 thread starter macrumors newbie

    Jan 10, 2010
    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