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

Ask Your Question

Averages not calculating correctly on Calc? [closed]

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

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 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

1 Answer

Sort by » oldest newest most voted

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

Ratslinger gravatar image

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

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 +0200 )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 +0200 )edit

Question Tools

1 follower


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

Seen: 196 times

Last updated: Jun 04 '17