| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sum a column of data
How do I sum a column of data in a macro?
Assume I have a worksheet and cells C1 through C20 have numbers. How can I get the sum of those numbers without a loop? I tried Total = Sum(Range("C1").End(xlDown)) But got an error that Sum is not defined as a funtion. DG |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Search for a column based on the column header and then past data from it to another column in another workbook | Excel Programming | |||
| Macro to paste data to a new column if previous column has data | Excel Programming | |||
| 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 Programming | |||
| 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) | |||
| Matching one column against another column of data to show the same amount of data. | Excel Worksheet Functions | |||
Threaded Mode
