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