Look up and Counts

Contributor

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

 

rhockman_0-1668702664289.png

 

 

 

1 Reply

@rhockman 

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.