| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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. |
|
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Automatic Display of ApproveIt Menu upon Excel Opening | Excel Discussion (Misc queries) | |||
| How to display remaining txt file which overflowed MsgBox display? | Excel Discussion (Misc queries) | |||
| Display Automatic formatting | Excel Discussion (Misc queries) | |||
| Display Automatic sentence after filter. | New Users to Excel | |||
| Is there an automatic display/print the filename on sheet in Exce. | Excel Discussion (Misc queries) | |||
Linear Mode
