Forum Discussion

rhockman's avatar
rhockman
Brass Contributor
Nov 17, 2022

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

 

 

 

 

excel
Formulas and Functions

1 Reply

  • dscheikey's avatar
    dscheikey
    Bronze Contributor
    Nov 18, 2022

    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.