ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Selected cells: item count versus summation (https://www.excelbanter.com/excel-discussion-misc-queries/49154-selected-cells-item-count-versus-summation.html)

Neal Zimm

Selected cells: item count versus summation
 
Used to be when I selected a range of cells, row or column, the sum would
show in the lower right part of the sceen.

I must have inadvertantly changed something, 'cuz now I get a count of the
selected cells.

How do I return to the former?
Thanks,
--
Neal Z

Gary''s Student

right click the word "count" at the bottom of the window and select sum.
--
Gary's Student


"Neal Zimm" wrote:

Used to be when I selected a range of cells, row or column, the sum would
show in the lower right part of the sceen.

I must have inadvertantly changed something, 'cuz now I get a count of the
selected cells.

How do I return to the former?
Thanks,
--
Neal Z


Neal Zimm

Thanks Much,
Do you know where this might be found in the Excel documenation?
Thanks again.
--
Neal Z


"Gary''s Student" wrote:

right click the word "count" at the bottom of the window and select sum.
--
Gary's Student


"Neal Zimm" wrote:

Used to be when I selected a range of cells, row or column, the sum would
show in the lower right part of the sceen.

I must have inadvertantly changed something, 'cuz now I get a count of the
selected cells.

How do I return to the former?
Thanks,
--
Neal Z


Cutter


In Help do a search on Status Bar.

From the topics that come up choose "Quick calculations on a worksheet"


--
Cutter
------------------------------------------------------------------------
Cutter's Profile: http://www.excelforum.com/member.php...fo&userid=9848
View this thread: http://www.excelforum.com/showthread...hreadid=474099



All times are GMT +1. The time now is 05:20 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com