View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
bestrugger bestrugger is offline
external usenet poster
 
Posts: 5
Default string lookup combined with SUM

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