auto sum feature

[Tammy]

Hi - new user. I've seen other people scroll over a group of cells and have
it quickly sum for them in the lower right corner without putting any
formulas into specific cells. Is this a feature that i need to "turn on"?
Thanks.

 

[Mike H]

Tammy,

Right click the 'Status bar', that's the bar below the sheet tabs and you
will see the functions available. Select 'Sum' select your range and the sum
is in the status bar.

Mike

 

[Gord Dibben]

Make sure the Status Bar is visible under View>Status Bar

Then right-click on the bar and select Sum.

Select the range of cells.


Gord Dibben MS Excel MVP