Forum Discussion

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

HansVogelaar

MVP

Jun 14, 2023

colee365

You might create a pivot table based on the data.

Add the subject to the rows area, the grade to the columns area and the student name to the values area.

Alternatively, create formulas using the COUNTIFS function

colee365
Copper Contributor
Jun 14, 2023
Thank you

I did try the countif but it doesn't like the + or - attached to the grades
- mtarler
  Silver Contributor
  Jun 14, 2023
  colee365 I don't understand why you say countif doesn't like the +/-. It seemed to work perfectly in the example I show below:
  
  EDIT: BTW you can see I'm using mixed text and numbers based on the left vs right justification and it works fine and even if I search text it finds the values (notice the 'number' 2 is left justified with the triangle indicating it is formatted as text instead of numeric.
- HansVogelaar
  MVP
  Jun 14, 2023
  colee365
  
  Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?
- SergeiBaklan
  Diamond Contributor
  Jun 14, 2023
  colee365
  
  I guess you have texts like "1-", "1", "1+", from that point of view COUNTIFS shall work as with any other text.