Situation: I have a Microsoft Form that is filled out by teachers to document student behaviors (up to 50 students) to find trends and correct their behavior over time. The results from the Form populate in an Excel spreadsheet in my OneDrive (the Form was created in my OneDrive > Forms for Excel).
What I'm looking to do: I would like to calculate the average of every row for a specific student under the column headings (Pride..., Academic..., Working..., Safe...) for every time a Form is filled out for that student. I have a sheet in this spreadsheet to gather this data.
Thoughts:
- I looked into using the vlookup and different average formulas. Not sure if I need to use a combination of those.
- I will be getting Form submissions daily on all of these students so I will need these averages to be constantly updating.
*Attached is a copy of the spreadsheet I'm working on