![]() |
adding columns
I am trying to find the formula for adding totals of columns at the bottom of
the paue !!! |
adding columns
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 --- |
adding columns
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 !!! |
adding columns
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 !!! |
All times are GMT +1. The time now is 09:50 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com