Google Spreadsheet Post #1957
Yogi Anand, D.Eng, P.E. ANAND Enterprises LLC -- Rochester Hills MI www.energyefficientbuild.com. May 15, 2015
post by Johanna Hart:
https://productforums.google.com/forum/#!category-topic/docs/spreadsheets/dIFaxU37jHs
Count only if 2 criteria are satisfied
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
Wednesday
Thursday
Thursday Mary Thursday
Thursday
-------------------------------------------------------------------------------------------------
No comments:
Post a Comment