Ask Your Question

Show total when selecting cells in Calc?

asked 2016-04-12 17:11:35 +0200

Scieri gravatar image

Hello all,

I have a calc sheet with a couple of columns that hold different numbers. I'm selecting an cell outside the filled columns and press the Sum button which gives me the possibility to select multiple cells on one column. The question is if is there any functionality that I don't know so when I'm selecting the cells also to see the total, like an tooltip or in status bar, like an realtime total of the selected cells so far? If I hit enter the total will be shown in the cell, but until then I see just the SUM formula and the number of the row/columns. This is helpful for me because I have to add certain rows and to have an total of certain value, which now I only see after I've hit enter on the Sum function.

edit retag flag offensive close merge delete

2 Answers

Sort by » oldest newest most voted

answered 2016-04-12 18:04:26 +0200

erAck gravatar image

The status bar has an area left of the zoom slider where the result of a few predefined functions with selected cells can be displayed, among them is SUM (e.g. Sum=0 displayed). Right mouse click on that status bar area pops up a menu with functions to choose from. Note however that the result is only updated if a cell is not in edit mode, i.e. does not display results while editing a formula.

edit flag offensive delete link more


Just note: Status bar can be switched off display - go to View / Status Bar - to turn it on.

bp gravatar imagebp ( 2017-04-03 07:32:13 +0200 )edit

answered 2016-04-12 18:29:37 +0200

Scieri gravatar image

Thank you for the response, that will do the trick :)

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2016-04-12 17:11:35 +0200

Seen: 2,985 times

Last updated: Apr 12 '16