Is there a quick / easy way to create totals for each pupil in the scenario below? I regularly extract data from our MIS and need to find totals for each pupil and put them in column F?. I can't find a way to do this in the MIS and wonder if there is a simple way to do this in Excel?
your question doesn't have enough info but as I understood it...
I think you should make another sheet which has the people sur and first name
and then using (sumifs) formulas you can get the totals like this (in the second sheet next to sur and first names in column C:C)