Countifs Function Error

%3CLINGO-SUB%20id%3D%22lingo-sub-2053501%22%20slang%3D%22en-US%22%3ECountifs%20Function%20Error%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2053501%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20using%20the%20COUNTIFS%20function%20for%20counts%20which%20meet%203%20criteria%3C%2FP%3E%3CP%3EGrade%2C%26nbsp%3BCourse%20level%2C%20%26amp%3B%20Town%3C%2FP%3E%3CP%3EHowever%2C%20it%20only%20works%20with%20two%20criteria%3F!%20I've%20only%20been%20spending%202%20hours%20on%20this..%20obviously%20I'm%20a%20newbie.%3C%2FP%3E%3CP%3E%3DCOUNTIFS('FinalGrades19-20'!%24W%242%3A%24W%2416742%2C%22Level%201*%22%2C'FinalGrades19-20'!%24F%242%3A%24F%2416742%2C%229%22%2C'FinalGrades19-20'!%24W%242%3A%24W%2416742%2C%22Anytown%22)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2053501%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2053559%22%20slang%3D%22en-US%22%3ERe%3A%20Countifs%20Function%20Error%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2053559%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F926526%22%20target%3D%22_blank%22%3E%40texera%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20sure%20there%20is%20no%20cell%20in%20W2%3AW16742%20which%20contains%20%22Level%201%22%20AND%20%22Anytown%22.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

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")

 

 

 

2 Replies

@texera 

I'm sure there is no cell in W2:W16742 which contains "Level 1" AND "Anytown".

 

@texera 

 

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.