Look up and Counts


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






1 Reply


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.