Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Averages not calculating correctly on Calc?

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:

image description

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.