Ask Your Question

How Do I average rows?

asked 2015-04-04 19:19:10 +0100

LinkMEP gravatar image

It will let me average columns but not rows, can I average rows? For example I am trying to average e4 through n4, but instead of getting the average it only gives me ###. The formula I am uses in =average(e4,n4)

edit retag flag offensive close merge delete

2 Answers

Sort by » oldest newest most voted

answered 2015-04-04 20:38:10 +0100

doug gravatar image

The formula seems ok; probably the other column is misformatted and unable to display the number. That is, the column with the row average probably is formatted to display a date or some text value.

On LO, Calc will average on row or column no problem.

(feel free to click the check (image description) to the left if the answer helps)

edit flag offensive delete link more

answered 2015-04-04 21:18:02 +0100

w_whalley gravatar image

The column width may be too small for the size of the answer. Try widening the column or changing the format to reduce the number of decimals displayed.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2015-04-04 19:19:10 +0100

Seen: 19,476 times

Last updated: Apr 04 '15