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.