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