Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Issue with "Average" showing in Status Bar
I have a large file of data, and there are some columns that do not display the average in the status bar, it only shows the count. I right clicked to make sure average is selected, and it is. The columns are all formatted the same way (general), so I cannot for the life of me figure out why I'm having this issue. If I type in the numbers in a separate column it allows me to see the average, but if I copy and paste special- values, it won't work. Anyone had this issue and know why it's not showing in random cells, even though they appear to be exactly the same (formatting, etc.)?
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Issue with "Average" showing in Status Bar
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Issue with "Average" showing in Status Bar
Your "numbers" are text.
Format an empty cell as General. Select and copy that cell. Select your data cells and Paste SpecialAddOKEsc The Average function should now proper results. Gord On Thu, 17 Apr 2014 05:57:34 -0700 (PDT), wrote: I have a large file of data, and there are some columns that do not display the average in the status bar, it only shows the count. I right clicked to make sure average is selected, and it is. The columns are all formatted the same way (general), so I cannot for the life of me figure out why I'm having this issue. If I type in the numbers in a separate column it allows me to see the average, but if I copy and paste special- values, it won't work. Anyone had this issue and know why it's not showing in random cells, even though they appear to be exactly the same (formatting, etc.)? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
EXCEL allow 2 options on status bar e.g. show "Count" + "Sum" | Excel Discussion (Misc queries) | |||
Copy Excel 2003 "status bar" sum to cell? | Excel Programming | |||
why do i sometimes not see the "Filter Mode" in Excel status bar? | Excel Worksheet Functions | |||
excel status bar says "double-click to edit PBrush" | Excel Worksheet Functions |