SUMIF l;ooks for multiple text options

[RodneyW]

I’m using these two formulas to sum the data in the appropriatecells:

=SUMIF($C$4:$C$200,"ORANGE",D$4:D$200)

=SUMIF($C$4:$C$200,"BLUE",D$4:D$200)

Both work perfectly. Now I need a formula that will sum thetotal if instead of looking specifically for ORANGE or BLUE, it looks for GREENor PURPLE or RED or YELLOW and totals the number if any of the cells meet thatcriteria. How do I modify?

TY in advance

 

[Aladin Akyurek]

Like this:

=SUM(SUMIF($C$4:$C$200,{"ORANGE","BLUE"},D$4:D$200))

=SUM(SUMIF($C$4:$C$200,{"GREEN","PURPLE","RED","YELLOW"},D$4:D$200))

 

[RoryA]

Like this:

=SUM(SUMIF($C$4:$C$200,{"GREEN","PURPLE","RED","YELLOW"},D$4:D$200))

 

[AlanY]

can just add them together

=SUMIF($C$4:$C$200,"ORANGE",D$4:D$200) + SUMIF($C$4:$C$200,"BLUE",D$4:D$200) + etc etc

 

[RodneyW]

Love it, several options! Started with the first one and it worked. Thank you all

 

[Aladin Akyurek]

You are welcome.