| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Summing a Column of Variable Length
Hello, me again,
Question: I would like to sum the values contained in Column D, on sheet "Master", and place total in Column Z, on sheet "Monthly". Hitch: the number in column D on sheet 'Master' is variable. How can i accomplish this? -- Carlee |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Summing a Column of Variable Length
=sum(Master!D:D)
if you mean with a macro tot = Application.Sum(Worksheets("Master").columns(4)) worksheets("Monthly").Cells(rows.count,"Z").End(xl up)(2) = Tot -- Regards, Tom Ogilvy "Carlee" wrote: Hello, me again, Question: I would like to sum the values contained in Column D, on sheet "Master", and place total in Column Z, on sheet "Monthly". Hitch: the number in column D on sheet 'Master' is variable. How can i accomplish this? -- Carlee |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Summing a Column of Variable Length
Hi there,
This works well....how can i copy this function down to specified cells in Column Z? -- Carlee "Tom Ogilvy" wrote: =sum(Master!D:D) if you mean with a macro tot = Application.Sum(Worksheets("Master").columns(4)) worksheets("Monthly").Cells(rows.count,"Z").End(xl up)(2) = Tot -- Regards, Tom Ogilvy "Carlee" wrote: Hello, me again, Question: I would like to sum the values contained in Column D, on sheet "Master", and place total in Column Z, on sheet "Monthly". Hitch: the number in column D on sheet 'Master' is variable. How can i accomplish this? -- Carlee |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Summing a Column of Variable Length
Sub Sum1()
Dim iEnd As Integer iEnd = Sheets("Master").Range("D1").End(xlDown).Row Sheets("Monthly").Range("Z1").Formula = "=SUM(Master!D1:D" & iEnd & ")" End Sub Hth, Merjet |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Summing a column based on the length of text in a cell in anothercolumn | Excel Worksheet Functions | |||
| Autosum a variable column length using VB | Excel Programming | |||
| Sum a Column of Variable length | Excel Discussion (Misc queries) | |||
| Sum a column of variable length? | Excel Discussion (Misc queries) | |||
| Averaging a variable length column | Excel Programming | |||
Linear Mode
