PDA

View Full Version : How do I reference a cell from within a condition in Numbers?




jgoody10
May 23, 2012, 09:38 AM
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.



jgoody10
May 23, 2012, 10:48 AM
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.