I have entered student rating data for lectures into Google Sheets, and I want to calculate the average. The data is structured as shown in the image. When I calculate the average for individual columns, the result is accurate, but when I try to calculate the average across all rows and columns, the result seems incorrect.
For example, instead of calculating the average by summing all the individual numbers like 5+5+5+5+4+5+5+5+5+5+4+5+5+4+5+5, it calculates something like (5555 + 4555 + 5545 + 5455) and then averages that.
I want to sum and average each individual number, not the combined values of rows or columns. How can I achieve this?