Apple Numbers SUMIF with multiple conditions
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!