RE: Lost TOTAL Icon

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Thanks Brad,
I don't want the syntax in the cell, I want the total, and only the total is
showing. I hope that's clear... I don't know else how to describe what I'm
trying to get in the total cell... don't want the syntax. Thanks and sorry
for my stupidity. Bill

"Brad Vogt" wrote:

They syntax is =sum(B4:B23) if you just want to fix it and get on to the next
thing.

"Bill" wrote:

Thank you FSt1... found the icon, highlighted the numbers in the column...
down to the total line and hit the total icon/sum icon. All I got was
=sum/B4/B23, the columns rows and not the total. Can you help? Thanks again
!
Bill

"FSt1" wrote:

hi
right click your tool bar and from the pop up, click customize.
on the customize dialog, click the command tab.
on the left side, click insert.
scroll down to auto sum. click and drag it to whereever you want it.

regards
FSt1

"Bill" wrote:

This is so basic it's embarrassing. I have not used Excel in several years.
I opened the program, typed in my numbers/amounts in a column, choose and
dragged down column for a total - AND, when I looked for the Total Icon, it
wasn't there. I have looked under every topic in tool bar area and cannot
find it. Somepone please assist. THANKS.
.

Relevant Pages

  • The most ridiculous thing Ive ever seen in comics.
    ... Anyway, Reed escapes the cell. ... Reed blows across the seams of the folded bill with an "absolutely ... worst example of "comic book physics" I've seen since the 60's. ... Inflatable lungs and a dollar bill, ...
    (rec.arts.comics.marvel.universe)
  • Re: Combined Abbreviated contidionts (was: PIC P put to real use
    ... I sent Bill some questionable syntax off-list some time ago. ... I continue to use abbreviated conditions, and I continue to get bit by ... Anyway, no, I don't expect COBOL to change this at this stage. ...
    (comp.lang.cobol)
  • Count values in a cell
    ... In a column where each cell has multiple text values separated by ... On another worksheet, I use the COUNTIF ... "Tom, George, Mary, Bill". ... Is there any way of separating ...
    (microsoft.public.excel)
  • Re: User Defined Function and VLookUP
    ... It is easy to see the formula even after applying protection as suggested ... Just copy a blank cell and then Edit> paste Special> Formats over ... , syntax wasn't working. ... "Jacob Skaria" wrote: ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Appending record with VBA when surname is True(sic)
    ... The fix you suggested via Bill ... Manville was also proposed by "onedaywhen" and it worked a treat. ... the type of thing which is called a macro in Excel ... >> based on processing the data cell by cell, so I suppose data types are ...
    (microsoft.public.access.macros)