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:

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.

The answer is correct. You are averaging B2 & D2 ((8+10)/2=9) just two cells.

What you want is =Average(B2:D2)

If this answers your question please click on the :heavy_check_mark: (upper left area of answer).

Oh ok thank you, I thought it was comma to do more than two rows. this is my first time using calc in a while, so it’s like baby steps all over for me again. But thank you tons. I’d give you an upvote but I just joined

@ybby Gave you upvote just to get you going. In case needed, here is the LO documentation site - click here.