hi
no i can't. i have never seen this behavior in excel before.
i have a column of numbers B3 to B15. when i auto sum i get =sum(B5:B15)
which is what you should have got also. i tried highlighting as you did with
the same results. i try not high lighting - same results. so now i am at a
loss. wish i could help and i did try. sorry.

regards
FSt1

"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.