Try this:

=SUMPRODUCT((ISNUMBER(SEARCH("cat",A1:A4)))*(B1:B4 ))

this adds up the rows that contain cat.

Hope this helps.

Pete

On Jul 2, 6:50*pm, bestrugger
wrote:
Hi, can someone offer any suggestions on how to add up some values based on a
column that contains a word that I specify. *For example:

Brown Cat * 2
Brown Dog *3
Tabby Cat * 2
Red Dog * * *4

What function can i use to add up on the those columns that contain "cat"? *
Thanks in advance.

DP