Thread: Sum a column
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Warren Warren is offline
external usenet poster
 
Posts: 7
Default Sum a column

To sum all the numbers in column A...
=SUM(a1:a11)
To sum all the numbers in column B...
=SUM(b1:b11)

----- newbie04 wrote: -----

i have a series of data :

2 2
5 5
7
1 1
0 0
3 3
6 6
10
2 2
9 9
11

The LHS is the original data while the RHS is the data i wanna obtain.
My doubts is that what is the code for summing?

Thank you.


---
Message posted from http://www.ExcelForum.com/