SUM: Display automatic

  • Thread starter Thread starter GaryW
  • Start date Start date
G

GaryW

when I highlight number fields, in the "lowerer" right of screen it shows a
COUNT of the rows i have selected...can I do the same for SUM? If I use
autosum it will store the result into a cell below my selection...want to
eliminate that step. In other words if I select 3 numeric cells...like to
see the sum of those values in the special area on the screen.???thx.
 
Place the cursor in the Status bar (where the count appears).
Right click and select SUM
 
Right-click on the Status Bar and change from Count to Sum.


Gord Dibben MS Excel MVP
 
Back
Top