JE McGimpsey wrote...
Simplest is probably:

=SUM(B1:B5)-SUMIF(A1:A5,"Green",B1:B5)
....

!?

Why not

=SUMIF(A1:A5,"<Green",B1:B5)

?