Monday, April 15, 2013

yogi_Compute Instances Of Words (specified in Sheet2) That Occur In Phrases In Column D Of Sheet1

                                          Google Spreadsheet   Post  #1132
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI    Apr 15, 2013
user Hassan Shahin :(!mydiscussions/docs/L1bitDAG_50)
Using Query with a condition that is in another sheet

How can I use the query function where the "where" part of the query should point to a column in another sheet. For example, Say I have Sheet1 and Sheet2. Sheet1 has columns, A, B, C. I want to have column A in Sheet2 have some values, and in column B of Sheet2, I want to populate, the sum or count of Column A of Sheet1 where the value contains what is column A of Sheet2. Many thanks and sorry if this might been answered before.

following is a solution to the problem