Status Bar Problem

[Doogs2009]

Hi
I want the sum of a column of data to show in the status bar, but it isnt. If I highlight the column, i want to be able to see the sum at the bottom in the status bar, and also the count and also the average. An adjacent column shows the sum but the column i need does not. I have checked the cell formatting for both columns and it is identical. What am I doing wrong? If anyone can pose a solution to this problem I would be most grateful. the adjacent columns are Column E and Column F in my worksheet, and both columns contain Text and Numbers. Column F is showing Count, Average and Sum in the Status Bar, but Column E is showing blank status bar figures.
Many thanks
Craig

 

[Doogs2009]

Ok, did what you said. I typed a number 1 just to the right of the table of data. Then I copied that. Then I highlighted the column in my table that is not giving me totals in the status bar. Then I right-clicked, pasted special, multiply (by 1). Column A values remained unchanged except the empty blank cells in that column now have zeroes in them. Alas!!! When I now highlight Column A and look for the totals in the Status Bar, they are not there, Count, Average Sum!!!! Can you suggest a permanent fix to this?
Thanks
Craig

 

[Doogs2009]

Sorry Jeff, i meant to say, the Count, Average Sum in the status bar are there now after doing the "mutliply" thing.
Craig

 

[jeffreybrown]

Hi Craig,

Well sure glad it all got sorted out.

As far as a permanent fix, a macro seems the only best or most viable solution. You could run it on the column if you find it not acting right again.

Do you import this data from somewhere?

 

[Doogs2009]

No, I copy and paste it from another source.

 

[jeffreybrown]

If this happens to you more than once, the data is corrupt that is, turn on the macro recorder and record the steps and there you go...the macro is done.

If you use the macro recorder it will add some stuff you may not need or better yet can be optimized.

Here is a tutorial which will explain some of what I am referring too.

If you don't understand the best way to clean up the macro you can paste it here and somebody can help you. Make sure you wrap any code with

[ Code ] insert code here [ / Code ]

You don't need the spaces.

If you do post some code for this, it is probably best to start a new thread especially since this post has a count of more than 14.

This will ensure your post gets as much attention as possible and especially because I may not be available.

P.S.
Forgot to mention. If you do not have a tab titled Developer on the ribbon then you will need to activate that option.

http://office.microsoft.com/en-us/e...tab-or-run-in-developer-mode-HA010173052.aspx

 

[Doogs2009]

Thanks for all your help Jeff. I have now recorded a macro and assigned a button on the worksheets where I need these totals to appear. Still a mystery to me why 2 adjacent columns with similar data/text in them, are not functioning or reading the format identically.
Have a great Easter.
Craig

 

[jeffreybrown]

You're welcome Craig...glad to see you got it all sorted out.

Here is another resource you might want to file away about Cleaning "Dirty" Data