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

Solution 1:

You can use REGEX:

SUMIF(A2:A114,REGEX("Blue|Green|Black"),F2:F114)