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.

___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.