Friday, May 15, 2015

yogi_From Table Of WeekDays And Names Of People Who Made Bookings Count Nuimber Of Bookings Made By Day Of Week

                                           Google Spreadsheet   Post  #1957
              Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI    May 15, 2015
post by Johanna Hart:!category-topic/docs/spreadsheets/dIFaxU37jHs
Count only if 2 criteria are satisfied
I have a long list of days of the week (A), and a long list of peoples names (B) who made the bookings. I want to produce a table (let's say columns C & D) which will count the number of bookings made on each day of the week. The issue I seem to be encountering is that each of the cells in column B have formula in them, so if I use ISTEXT(B2) it counts the formula as text, even if the box is 'empty.' 

I have been creating a long column out of sight (let's say column E) to match the amount of data in columns A & B, and using a IF 'all of criteria in column B2 cell' (to avoid the ISTEXT issue) then, A2.  And then using my C & D table space to Count each of the days of the week in column E- =COUNTIF(E2:E500,C2).

I am sure that there must be an easier way to create a table (C & D) that counts the number of names in column B for each day of the week..?

Would appreciate your help very much!

A                              B                C                         D                   E
Monday                   Sam            Monday               3                   Monday
Monday                   Ed               Tuesday              1                   Monday
Monday                   Mary           Wednesday         2                   Monday
Monday                                      Thursday             1
Monday                                       Friday                 0
Tuesday                  Tom             Saturday            0                    Tuesday 
Wednesday             Sam             Sunday              0                    Wednesday
Wednesday             Sam                                                             Wednesday 
Thursday                 Mary                                                            Thursday