Ask Your Question

Averages not calculating correctly on Calc?

asked 2017-06-03 23:35:03 +0100

ybby gravatar image

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.

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2017-06-04 00:28:06 +0100

Ratslinger gravatar image

updated 2017-06-04 01:29:19 +0100

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 ✔ (upper left area of answer).

edit flag offensive delete link 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

ybby gravatar imageybby ( 2017-06-04 01:47:23 +0100 )edit

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

Ratslinger gravatar imageRatslinger ( 2017-06-04 03:03:12 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2017-06-03 23:35:03 +0100

Seen: 66 times

Last updated: Jun 04 '17