Google Spreadsheet Post #2551
Yogi Anand, D.Eng, P.E. ANAND Enterprises LLC -- Rochester Hills MI Nov-24-2018
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:
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