Forum Discussion
+/- 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 +...
Thank you
I did try the countif but it doesn't like the + or - attached to the grades
I did try the countif but it doesn't like the + or - attached to the grades
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.