SUM: Display automatic
 

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.

Display automatic
 

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

--
Biff
Microsoft Excel MVP


"GaryW" wrote in message
...
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.

Display automatic
 

Many thanks to U.

"T. Valko" wrote:

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

--
Biff
Microsoft Excel MVP


"GaryW" wrote in message
...
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.

SUM: Display automatic
 

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


Gord Dibben MS Excel MVP

On Thu, 15 May 2008 14:20:01 -0700, GaryW
wrote:

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.

Display automatic
 

You're welcome!

--
Biff
Microsoft Excel MVP


"GaryW" wrote in message
...
Many thanks to U.

"T. Valko" wrote:

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

--
Biff
Microsoft Excel MVP


"GaryW" wrote in message
...
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.