ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   adding columns (https://www.excelbanter.com/new-users-excel/218284-adding-columns.html)

Munro

adding columns
 
I am trying to find the formula for adding totals of columns at the bottom of
the paue !!!

Max

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

Suleman Peerzade[_2_]

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 !!!


Shane Devenshire[_2_]

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