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     www.energyefficientbuild.com.   Apr-11-2014
post by Christopher MT: (https://productforums.google.com/forum/#!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



No comments:

Post a Comment