Forum Discussion
Mix between vlookup and sum command?
Hello, I am making an excel spreadsheet for my fiancé who is a first year teacher. She needs to report grades every 10 weeks. There are kids who are regular students (Denoated as ‘REG’). There are al...
DanTheeMan11 It sounds like you're looking for a count of students by category and by grade range. I would recommend the COUNTIFS function for this. Please see the attached sample workbook to help get you started...