Friday, April 11, 2014

yogi_Sum Cost For KeyWord Items In Column A For Specified Month

                                         Google Spreadsheet   Post  #1598
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI   Apr-11-2014
post by Christopher MT: (!category-topic/docs/spreadsheets/0Nfl_7HZYxg)
Sum amount where any list of words are found in cell.
Hi, I have a table that looks like this:
I want to create another table that looks for "Key words" anywhere in COLUMN A and sums COLUMN B for month 1 only.
Thanks for any help I can get.
in the following is the solution to a bit more generalized problem ...

note: my result for WASHER is $65 compared to Christopher MT's posted result of $68