Saturday, September 14, 2013

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
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).
PersonAvailabilitySTATUS
BobMondays, Tuesdaysapproved
JoeMondays, Wednesdays
FishMondays, Tuesdays, Wednesdaysapproved

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

RESULTS (on another sheet))
MondaysTuesdaysWednesdays
221

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

-----------------------------------------------------------------------------------------------------------------------------------------------------------

No comments:

Post a Comment