Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default Count will not go away.

I work with Excel 2003 and have noticed that when I extracta reports into
Excel from another program and then save it, I am no longer able to highlight
rows or columns of numerical date and get a total in the lowr right hand
corner. I am now getting Count = and then the number of rows. How What do I
have to change to be able to get my ability to see a total of the numerical
date and not the count of rows?
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,646
Default Count will not go away.

Right click on the status bar where you see Count=x and choose Sum from the
local menu!
Regards,
Stefi

€žeortiz63€ť ezt Ă*rta:

I work with Excel 2003 and have noticed that when I extracta reports into
Excel from another program and then save it, I am no longer able to highlight
rows or columns of numerical date and get a total in the lowr right hand
corner. I am now getting Count = and then the number of rows. How What do I
have to change to be able to get my ability to see a total of the numerical
date and not the count of rows?

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Multiple Criteria, Count If, Sum Product to get count across range Jonathan Excel Worksheet Functions 5 January 9th 08 11:32 PM
Count Employee Work Time - Don't Double-count Overlapping Apts. J Excel Worksheet Functions 0 April 27th 07 05:52 AM
Excel 2000, count, sort a list & count totals? sunslight Excel Worksheet Functions 1 April 9th 07 05:46 PM
Count Intervals of 2 Consecutive Values in same Row and Return Count across Row Sam via OfficeKB.com Excel Worksheet Functions 6 November 29th 05 03:27 PM
Count Intervals of Filtered TEXT values in Column and Return Count across a Row Sam via OfficeKB.com Excel Worksheet Functions 9 July 31st 05 03:37 AM


All times are GMT +1. The time now is 08:01 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"