Ask Your Question

how do I add an average button in calc ? [closed]

asked 2013-08-26 12:22:32 +0200

pangit gravatar image

I cannot see how I can add an "average" button in Calc. I can see the "sum" button, but would like an average button also. Is this possible ?

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2015-11-07 11:00:52.007693

2 Answers

Sort by » oldest newest most voted

answered 2013-08-27 08:37:14 +0200

rveerd gravatar image

I like the sum button because it automatically selects the rows above. If I need another function, such as the mean, I still use the button and change the formula, e.g. from something like SUM(A1:A2) to AVERAGE(A1:A2).

edit flag offensive delete link more

answered 2013-08-26 13:43:25 +0200

Kunjomachen gravatar image

Sure. You can record a macro and assign a button to it

edit flag offensive delete link more

Question Tools

1 follower


Asked: 2013-08-26 12:22:32 +0200

Seen: 6,886 times

Last updated: Aug 27 '13