Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default Cant use sum function or status bar

My auto sum will not work have followed help function and still no joy select
cell below and formula appears click auto sum twice and error message. Tried
to update status bar (right click for menue) none of my selections other than
count show.
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 8,520
Default Cant use sum function or status bar

Check whether the cells are in text format. (Right clickFormatCells). To
convert the cells to numerics do the below.
--Copy a blank cell
--Keeping the copy select the range of cells with numeric values
--Right clickPasteSpecial
--Select 'Add' and click OK and check your status bar

If this post helps click Yes
---------------
Jacob Skaria


"Medways" wrote:

My auto sum will not work have followed help function and still no joy select
cell below and formula appears click auto sum twice and error message. Tried
to update status bar (right click for menue) none of my selections other than
count show.

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
Status Bar Steve Excel Discussion (Misc queries) 1 June 9th 09 03:20 PM
Status Bar: SUM function doesn't work for numbers copied from web suriogl Excel Discussion (Misc queries) 4 August 27th 08 12:32 AM
Status Bar - SUM function adding grouped cells slippyslappy Excel Discussion (Misc queries) 0 July 11th 08 02:45 AM
reuest formula for auto update status & status date PERANISH Excel Worksheet Functions 5 June 2nd 08 04:26 PM
Add a function to the status bar? [email protected] Excel Discussion (Misc queries) 1 July 17th 06 07:37 PM


All times are GMT +1. The time now is 09:24 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"