How to average data for one specific user?

[Riku_Marasa]

Hi everyone,

I’m new to this. I have created a table to collect student grades. I collect the data on a form and populate the Student and Score fields by use of a form. Thus, I have many different names in my Student field. When I filter the names, I easily separate out any specific student’s scores over the previous 20 tests. But, I cannot figure out how to AVERAGE these scores for each student. Can this be done, or is my data collection method fundamentally flawed and I should start over again?

Happily accept everything but blows.
:slightly_smiling_face:

[Riku_Marasa]

Only just figured out how to do that.

[Riku_Marasa]

Wait it is working if I use the dropdown menu still to average the records. Well done. Thanks for your patience. Please direct me to the best beginners’ tutorial videos. I think I have much to learn.

[ScottWorld]

Wonderful! :slightly_smiling_face: Please be sure to mark my comment above as the correct solution — you accidentally marked your own comment as the solution.