Nov 17 2022 08:33 AM
I cannot figure out to do this any help is welcomed. I want the counts of students in Row B that have 100% passing data from another tab. So matching the student ID and the month to count just these students with %100.
=COUNTIFS('Student Data'!D:D,??,'Student Data'!AL:AL,"9",'Student Data'!E:E,"100%")
Nov 18 2022 09:46 AM
Most likely, your cell is a percentage. Therefore, you have to search for the 1.
=COUNTIFS('Student Data'!D:D,??,'Student Data'!AL:AL,"9",'Student Data'!E:E,1)
If that doesn't work, you should upload a sample file here.