Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
I am trying to find the formula for adding totals of columns at the bottom of
the paue !!! |
#2
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
formula for adding totals of columns at the bottom ..
Eg in A11: =SUM(A1:A10) will add up numbers in the range above: A1:A10 You can copy A11 across to return the corresponding sums for cols B, C, D, etc -- Max Singapore http://savefile.com/projects/236895 Downloads:22,500 Files:370 Subscribers:66 xdemechanik --- |
#3
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
Hi,
You can select the cells and in the menubar click the auto sum icon it will give you the total. for eg. you have data A1:A10 select the cells from A1:A11 and press the auto sum icon. Done -- _______________________ Click "Yes" if it helps ________ Thanks Suleman Peerzade "Munro" wrote: I am trying to find the formula for adding totals of columns at the bottom of the paue !!! |
#4
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
Hi,
Suppose you have data in A1:D25 and you want sums in A26:D26 1. Highlight the range A1:D25 2a. Click the AutoSum button or 2b. Press Alt+= (Alt and the Equal key) -- If this helps, please click the Yes button Cheers, Shane Devenshire "Munro" wrote: I am trying to find the formula for adding totals of columns at the bottom of the paue !!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Adding Columns, Then deleting old columns | Excel Discussion (Misc queries) | |||
adding columns | Excel Worksheet Functions | |||
Adding Columns | Excel Discussion (Misc queries) | |||
Adding Columns | Excel Discussion (Misc queries) | |||
adding columns | Excel Discussion (Misc queries) |