rhockmanBrass ContributorNov 17, 2022Look 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...Show More
dscheikeyBronze ContributorNov 18, 2022rhockman 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.
