Team- I upgraded to Excel 2013- BIG mistake... but so be it.  In all previous versions of Excel if I highlight a number of cells, the status bar at the bottom showed the number of highlighted cells.  Now in 2013 that count is gone- just GONE!  I right-clicked the status bar and made sure "Count" and "Numerical Count" were highlighted, but still nothing.  Just a blank status bar which only says "Ready".  This is a very simple, very obvious, and very important function I need on a daily basis.  I cannot imagine- cannot even begin to imagine what some ivory-tower-living programmer was thinking to hide this function from users in a SPREADSHEET PROGRAM, but for the moment I'll put that aside.  Anyone know how to turn it back on?

TIA (Thanks in Ad

Firstly, this feature still exists in excel 2013.

But Im not really sure why the count is gone in your excel program, since you said the status bar is visible, also you have already right click the status bar and tick the option count.
By the way, I wonder to know if you can see the values when you right click the status bar?
And  you can check if you set the calculation as manual, if so ,turn it to automatic.

If it doesnt bring help,  try to repair your office program:
http://office.microsoft.com/en-in/project-help/repair-or-remove-office-HA010357402.aspx

• Marked as answer by Tony Chen CHNMicrosoft contingent staff, Moderator Monday, December 02, 2013 3:38 PM

Firstly, this feature still exists in excel 2013.

But Im not really sure why the count is gone in your excel program, since you said the status bar is visible, also you have already right click the status bar and tick the option count.
By the way, I wonder to know if you can see the values when you right click the status bar?
And  you can check if you set the calculation as manual, if so ,turn it to automatic.

If it doesnt bring help,  try to repair your office program:
http://office.microsoft.com/en-in/project-help/repair-or-remove-office-HA010357402.aspx

• Marked as answer by Tony Chen CHNMicrosoft contingent staff, Moderator Monday, December 02, 2013 3:38 PM

Firstly, this feature still exists in excel 2013.

But Im not really sure why the count is gone in your excel program, since you said the status bar is visible, also you have already right click the status bar and tick the option count.
By the way, I wonder to know if you can see the values when you right click the status bar?
And  you can check if you set the calculation as manual, if so ,turn it to automatic.

If it doesnt bring help,  try to repair your office program:

I know this is digging up an old thread, but I haven't been able to find any other information out about this either. I am running into the same problem with the display of a cell count in the status bar, but only for BLANK cells. In previous versions of Excel, you could highlight a range of blank cells and it would display the cell count in the status bar. With Excel 2013, it only displays the count if there is data in a cell. For instance, if you highlighted a total of 5 cells, but only 2 had data in them, the count display in the status bar would read 2. If you highlight a range of all blank cells, the display is just simply not there. I'm curious to know why this feature was removed or "turned off" and how we can get it working again, as it was a VERY useful feature.

Thanks!

Trying to refresh this post if possible. The answer listed above does not answer the question. The original statement, and my current issue, is counting highlighted cells. The answer noted above only works on cells with content. Is there a way to configure the status bar to count selected cells as it did in Excel 2010? 

Hey Knight!

I encountered the same issue today! and I noticed that these formulas did not work with a worksheet that someone else created! but all those formulas work fine in the status bar if I open an excel sheet I created!

I am not sure if this is a security setting or a bug.. but wanted to let you know you are not crazy.. lol.. I replicated the issue; for me,  only 'Count' works even though all other settings are checked (in someone else's worksheet)..

when I open an excel sheet I created, all formulas I selected work ok...!

perhaps is the settings of the other person or maybe even excel version... not sure... just wanted to let you know... (reinstalling the program probably won't do much!) not sure that is a 'resolution'...

Test creating your own sheet and see if those formulas show or not then? (if they do, then copy the data from that other worksheet into yours; that may be a work around for now...) post your results if you can!