Cells not adding totals, Excel 2000

[Ron]

Hi,

I started to have a problem with excel, I used to be able
to highlight the cells and was able to see the totals at
the bottom,but for some reason this feature had stopped
working. I no longer can see the totals. I've removed
office and re-installed it but no change. Any input is
appreciated. Thanks

 

[Paul B]

Ron, working on '97 right now but I think it should be in the same place, go
to tools options and check status bar

--
Paul B
Always backup your data before trying something new
Using Excel 97 & 2000
Please post any response to the newsgroups so others can benefit from it
** remove news from my email address to reply by email **

 

[Tushar Mehta]

[This followup was posted to microsoft.public.excel.worksheet.functions
with an email copy to Ron.
Please use the newsgroup for further discussion.]

Chances are those cells contain text. Try the following:

(1) In some cell next to a cell that contains what appears to be a
number, enter =ISNUMBER(<cell-of-interest>) What do you get?

(2) Select an empty cell. Copy. Select the cells of interest. Edit |
Paste Special... | Operation section | Select Add. Click OK. Does
that solve the problem?

--
Trouble finding replies to your posts? Use a newsreader. See the
tutorial 'Outlook Express and Newsgroups' on my web site

Regards,

Tushar Mehta (www.tushar-mehta.com) MS MVP - Excel

 

[Ron]

Actualy I didn't decribe the problem properly. he issue
is when I attemt to add the numbers in the cells, the
status bar is visible but all I get is Min= first cell
only.

Tnanks

 

[AndyB]

Ron

Right click where the 'Min' comes up and you get the choice of which
function you want - eg sum, max, average - and this will become default

Andy