A couple of ways

=SUM(SUMIF(A2:A6,{"Red";"Green"},B2:B6))

or

=SUMPRODUCT(--((A2:A6="Red")+(A2:A6="Green")0),B2:B6)

both returns 57


--
Regards,

Peo Sjoblom



"Kazmaniac" wrote in message
...
Please help
I am trying to add numerical values in one column based on multiple values
in another column.

A B
Red $24
Blue $16
Green $21
Blue $15
Green $12

I would like to add the values in column B for all rows that have a value
of
red and green in column A. Thank you in advance for your help!