Jan 12 2021 08:54 AM
I am using the COUNTIFS function for counts which meet 3 criteria
Grade, Course level, & Town
However, it only works with two criteria?! I've only been spending 2 hours on this.. obviously I'm a newbie.
=COUNTIFS('FinalGrades19-20'!$W$2:$W$16742,"Level 1*",'FinalGrades19-20'!$F$2:$F$16742,"9",'FinalGrades19-20'!$W$2:$W$16742,"Anytown")
Jan 12 2021 09:14 AM
Jan 12 2021 09:38 AM
The formula structure is correct,
What are the two criteria that works with you? how sure you are that is is not working?
Would you please share your workbook with us, so we can help you.
* If my post helped you, please click on like.