so I’m doing a poll sort of thing and the averages aren’t coming out correctly. people are rating the songs out of ten, and when I averaged out their votes, the average came out incorrectly:
if you’re wondering, the pixelated parts in B, C, and D are people’s names, formatted in bold.
8+3+10 is 21, and 21 divided by three is 7, not 9 which is what the AVERAGE function is displaying. I have no idea if it’s A1 being blank or E1 being blank… or what… I need help. I don’t know what I’m doing wrong.