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.