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.