Tuesday, May 28, 2013

yogi_Query Data in Range From A29 to D For A Month Specified In cell C2

                                          Google Spreadsheet   Post  #1216
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   May 28, 2013
user user jsarch (http://productforums.google.com/forum/#!category-topic/docs/spreadsheets/BbmjgU4sdyQ)
Filtering Data w/ Query
I know query is exactly the tool I need to use, I just have no idea how to use it!

I have the following query function:
=query(B29:D;"select B,sum(D) where B <> '' group by B label sum(D) '' ")

and it works fine, except now, I need to filter the data in column B based on what is in column A, before the query works its magic. I'd typically just use Filter, I'm thinking that ALL of this can probably be done with query, I just have no idea how.

You can see the query function in C6, and it's adding up all the hours in rows 29 and below, except I want to filter those hours based on the date in column A. And there is a drop down menu in C2 that I choose which date I'm looking at.

Does anyone have any ideas?