Saturday, November 24, 2018

yogi_Multi-Conditional Count Computation

Google Spreadsheet   Post  #2551

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     Nov-24-2018

How can I count cells in a row that contain 2 different criteria in 2 different columns
My database has 2 parameters that must be met in order to make a count.   I want to count the number of times an instructor taught in a month.  One column lists that date (day month date and year) and the next lists the instructor.  I cant seem to get the formula to count if both criteria are met.  So for example I have:

Friday, November 2, 2018WENDY
Saturday, November 3, 2018RUMI
Monday, November 5, 2018RHIAN
Wednesday, November 7, 2018MICHELLE
Friday, November 9, 2018MICHELLE
Saturday, November 10, 2018WENDY
Monday, November 12, 2018RHIAN
Wednesday, November 14, 2018RUMI
Friday, November 16, 2018MICHELLE
Saturday, November 17, 2018WENDY
Monday, November 19, 2018RUMI
Wednesday, November 21, 2018RHIAN
Friday, November 23, 2018MICHELLE
Saturday, November 24, 2018WENDY
I want to count the number of times Michele taught in November.  I'm using this formula 

=COUNTIF(A11:B60, "*November*" + COUNTIF(A11:B60, "Michelle"))

but its not picking up anything. What am I doing wrong??

Please help!

No comments:

Post a Comment