yogi_Compute Number Of Approved Status Items By WeekDay From A Table Of Person WeekDay And Approval Status

                                          Google Spreadsheet   Post  #1368
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Sep 10, 2013

user Mo S (http://productforums.google.com/forum/?zx=12tctimpyndk#!category-topic/docs/spreadsheets/ud1L2SvDIpc)

Query function to count rows that has both: 1) contain a string in one cell and 2) contains specific text in another cell

Here's what my sheet looks like (based on form responses).

Person	Availability	STATUS
Bob	Mondays, Tuesdays	approved
Joe	Mondays, Wednesdays
Fish	Mondays, Tuesdays, Wednesdays	approved

Here's what i want the results to look like:

RESULTS (on another sheet))
Mondays	Tuesdays	Wednesdays
2	2	1

Basically, the query function needs to count how many ppl are available on those days that are also approved.

The query function i currently use does not consider the 3rd column becuz i dont know how to make it:s

Any help appreciated. Thanks.

I am using firefox/win 7
-----------------------------------------------------------------------------------------------------------------------------------------------------------