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 "The formula contains a number outside the valid range." 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,{"Blue"},F2:F114))
but this does not
SUM(SUMIF(A2:A114,{"Blue","Green","Black"},F2:F114))
Please use a working formula example in your answer. Thanks.
Best Answer
This works.
Another example of why Numbers is inferior to Microsoft Excel!