We will be migrating from Ask to Discourse on the first week of August, read the details here

# Averages not calculating correctly on Calc? [closed]

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.

edit retag reopen merge delete

### Closed for the following reason the question is answered, right answer was accepted by Alex Kemp close date 2020-10-05 23:17:37.076813

Sort by » oldest newest most voted

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

What you want is =Average(B2:D2)

more

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

( 2017-06-04 01:47:23 +0200 )edit

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

( 2017-06-04 03:03:12 +0200 )edit