If I understood what you want:

=SUMPRODUCT(--(MMULT(--(ISNUMBER(SEARCH({"red","blue","circle","square"}, A2:A9))),{1;1;1;1})0),B2:B9)

--
Biff
Microsoft Excel MVP


"Kev30" wrote in message
...
I would like to know if there is a way in excel to sumif based on if the
data contains particular words. For example; column A has data like (blue
circle, red circle, yellow circle, blue square, red square and so on.)
Column B has how many of each sold. I want to sum all the rows in column
A
that contain a particular word (Circle, Square, Red, or Blue). I hope
this
makes sense and any help would be great.

Thanks, Kevin