Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 66
Default sometimes the sum function will dissappear

i'm using excel 2002. do you know that tool down at the bottom that will add
the numbers in all the cells that you select? quite often it will stop
working. does anyone know how to get it working again.

also could you please tell me how i look up the threads that i've started?
it's obvious. i've tried looking in the user control panel and i don't see
it anywhere.
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 52
Default sometimes the sum function will dissappear

Click on your name and then recent posts in the window that opens.
--
Russell Dawson
Excel Student


"kyle" wrote:

i'm using excel 2002. do you know that tool down at the bottom that will add
the numbers in all the cells that you select? quite often it will stop
working. does anyone know how to get it working again.

also could you please tell me how i look up the threads that i've started?
it's obvious. i've tried looking in the user control panel and i don't see
it anywhere.

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default sometimes the sum function will dissappear

Are you selecting more than one cell when the statusbar fails?

How does it fail?

If you're using Sum or Max or any numeric function, are you sure that the values
are numeric--not just text?

If it disappears, make sure the statusbar is visible:
Tools|Options|view tab|check status bar.

=====
I use google to search groups.

http://groups.google.com/advanced_se...blic.excel. *

Give it enough information (you as the author, maybe a keyword or date) and
you'll find it.



kyle wrote:

i'm using excel 2002. do you know that tool down at the bottom that will add
the numbers in all the cells that you select? quite often it will stop
working. does anyone know how to get it working again.

also could you please tell me how i look up the threads that i've started?
it's obvious. i've tried looking in the user control panel and i don't see
it anywhere.


--

Dave Peterson
  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 22,906
Default sometimes the sum function will dissappear

Right-click on the Status Bar and make sure you are not set to "none"


Gord Dibben MS Excel MVP

On Thu, 11 Feb 2010 17:36:01 -0800, kyle
wrote:

i'm using excel 2002. do you know that tool down at the bottom that will add
the numbers in all the cells that you select? quite often it will stop
working. does anyone know how to get it working again.

also could you please tell me how i look up the threads that i've started?
it's obvious. i've tried looking in the user control panel and i don't see
it anywhere.


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
Excel Data Validation/Lookup function does function correcty Kirkey Excel Worksheet Functions 2 May 25th 09 09:22 PM
LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) [email protected] Excel Worksheet Functions 0 September 5th 06 03:44 PM
Values Dissappear when entering asiffaleel New Users to Excel 1 May 3rd 06 09:41 AM
Offset function with nested match function not finding host ss. MKunert Excel Worksheet Functions 1 March 21st 06 10:46 PM
Format cell so zeros don't dissappear? Neenah Excel Discussion (Misc queries) 4 January 18th 06 08:43 PM


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