Ask Your Question
0

How Do I average rows?

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

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
0

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

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
0

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

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 4.4.2.2, 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
Login/Signup to Answer

Question Tools

1 follower

Stats

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

Seen: 22,847 times

Last updated: Apr 04 '15