Apple Numbers SUMIF with multiple conditions I recently switched to Numbers from Mac Excel and a formula is not working. I am taking the sum of a range of cells where a SUMIF condition is met. The formula worked in Mac Excel but Apple Numbers returns an error &quot;The formula contains a number outside the valid range.&quot; It's obvious that SUMIF condition syntax is not valid in Numbers, but I cannot find any documentation or example to correctly format it. I have looked at SUMIFS with the same result.
For example, this works in Numbers
SUM(SUMIF(A2:A114,{&quot;Blue&quot;},F2:F114))

but this does not
SUM(SUMIF(A2:A114,{&quot;Blue&quot;,&quot;Green&quot;,&quot;Black&quot;},F2:F114))

Please use a working formula example in your answer. Thanks.
This works.
SUM(SUMIF(A2:A114,&quot;Blue&quot;,F2:F114),SUMIF(A2:A114,&quot;Green&quot;,F2:F114),SUMIF(A2:A114,&quot;Black&quot;,F2:F114))

Another example of why Numbers is inferior to Microsoft Excel!