Forum Discussion

colee365's avatar
colee365
Copper Contributor
Jun 14, 2023

+/- Student Grade Formula Question

Good afternoon, I work in a secondary school and we use the following grades: 1-, 1, 1+, 2-, 2, 2+, etc. I need to calculate the number of students that got a 1- etc in each subject. Obviously the +...
Formulas and Functions
PeterBartholomew1's avatar
PeterBartholomew1
Silver Contributor
Jun 14, 2023

colee365 

This is intended as a dynamic range version of a crosstab count.

= LET(
    distinctName, SORT(UNIQUE(Name)),
    gradeList,    TOROW(gradeValidation),
    countGrades,  COUNTIFS(Name, distinctName, Grade, gradeList),
    crossTab,     IF(countGrades, countGrades, ""),
    VSTACK(
      HSTACK("Count", gradeList), 
      HSTACK(distinctName, crossTab)
    )
  )

Resources