Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 2
Default adding columns

I am trying to find the formula for adding totals of columns at the bottom of
the paue !!!
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Max Max is offline
external usenet poster
 
Posts: 9,221
Default 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
---
  #3   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 189
Default 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 !!!

  #4   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 3,346
Default 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 !!!

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Adding Columns, Then deleting old columns May Excel Discussion (Misc queries) 4 October 30th 08 04:44 PM
adding columns Masterzan Excel Worksheet Functions 2 October 29th 08 09:15 AM
Adding Columns Kevin Excel Discussion (Misc queries) 6 January 8th 08 07:15 AM
Adding Columns Paul Sheppard Excel Discussion (Misc queries) 3 July 28th 05 10:59 AM
adding columns Garry Excel Discussion (Misc queries) 1 March 17th 05 10:20 PM


All times are GMT +1. The time now is 12:04 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"