| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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/ |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| divide column(x) by column(y) to give column(x/y) in excel? | New Users to Excel | |||
| Referencing date column A & time column B to get info from column | Excel Discussion (Misc queries) | |||
| Return text in Column A if Column B and Column K match | Excel Worksheet Functions | |||
| Based on a condition in one column, search for a year in another column, and display data from another column in the same row look | Excel Discussion (Misc queries) | |||
| what formula do i put for column m = column k minus column l in e. | Excel Discussion (Misc queries) | |||
Threaded Mode
