Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I am looking to sum several columns (see below) and have the totals listed
on the last line for each column. I also want to insert the text "TOTAL:" on the same line in column A. Following is where I am but I am stuck. Any help would be appreciated. Thanks, Met CODE, So far: Application.sum (Range("D2:D")) Application.sum (Range("E2:E")) Application.sum (Range("F2:F")) Application.sum (Range("G2:G")) Application.sum (Range("H2:H")) Application.sum (Range("I2:I")) Application.sum (Range("J2:J")) Application.sum (Range("K2:K")) Application.sum (Range("L2:L")) Application.sum (Range("M2:M")) Application.sum (Range("N2:N")) Application.sum (Range("O2:O")) Application.sum (Range("P2:P")) Application.sum (Range("Q2:Q")) Application.sum (Range("R2:R")) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Pivot Totals: Group totals different from Grand totals | Excel Discussion (Misc queries) | |||
how to enter totals and sub totals from receipts into excel. | New Users to Excel | |||
Summing Weekly Totals into Monthly Totals | Excel Worksheet Functions | |||
How do I sum YTD totals based on monthly totals | Excel Discussion (Misc queries) | |||
Comparing/matching totals in a column to totals in a row | Excel Worksheet Functions |