SUM: Display automatic

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.
 
T

T. Valko

Place the cursor in the Status bar (where the count appears).
Right click and select SUM
 
G

Gord Dibben

Right-click on the Status Bar and change from Count to Sum.


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Auto Sum issue 2
Excel Sum numbers in cells that also contain text 34
sum of cells containing text 3
Invoke AutoSum From VBA? 4
SUM / COUNT formula 3
Problem with pasting value of a sum 3
easy one - multipule formulas in one cell 5
An odd problem with SUM(A:B) and AutoSum 2

Top