Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
summing in vba
im using excel to build a labour list from an ms project data file
the job im trying to do is sum column after i populate it using a pair of for loops so the only thing method i have of identifying the files i need to sum is the counters of the loops. I can do it via so more loops and an extra variable. What i want to know is: is there a simpler way to do it? perhaps an expression that i could use something along the lines of: cell.value = "=sum(counter:counter1)" thanks in advance for any help |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
summing in vba
If you know the column that you are putting the data in, for instance, column
F, then you could use: Sub addItup() Dim mySum As Double mySum = WorksheetFunction.Sum(Range("F2":F" _ & Range("F65536").End(xlUp).Row) MsgBox mySum End Sub That would give you the sum of the values in column F as a dynamic range, assuming a header row. "Joseph Atie" wrote: im using excel to build a labour list from an ms project data file the job im trying to do is sum column after i populate it using a pair of for loops so the only thing method i have of identifying the files i need to sum is the counters of the loops. I can do it via so more loops and an extra variable. What i want to know is: is there a simpler way to do it? perhaps an expression that i could use something along the lines of: cell.value = "=sum(counter:counter1)" thanks in advance for any help |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
summing in vba
I might have left a bracket off. If so you will get a run time error. Just
add a parenthesis on the end. "Joseph Atie" wrote: im using excel to build a labour list from an ms project data file the job im trying to do is sum column after i populate it using a pair of for loops so the only thing method i have of identifying the files i need to sum is the counters of the loops. I can do it via so more loops and an extra variable. What i want to know is: is there a simpler way to do it? perhaps an expression that i could use something along the lines of: cell.value = "=sum(counter:counter1)" thanks in advance for any help |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
summing in vba
I did miss one. Here is what it should be:
mySum = WorksheetFunction.Sum(Range("F2":F" _ & Range("F65536").End(xlUp).Row)) "JLGWhiz" wrote: If you know the column that you are putting the data in, for instance, column F, then you could use: Sub addItup() Dim mySum As Double mySum = WorksheetFunction.Sum(Range("F2":F" _ & Range("F65536").End(xlUp).Row) MsgBox mySum End Sub That would give you the sum of the values in column F as a dynamic range, assuming a header row. "Joseph Atie" wrote: im using excel to build a labour list from an ms project data file the job im trying to do is sum column after i populate it using a pair of for loops so the only thing method i have of identifying the files i need to sum is the counters of the loops. I can do it via so more loops and an extra variable. What i want to know is: is there a simpler way to do it? perhaps an expression that i could use something along the lines of: cell.value = "=sum(counter:counter1)" thanks in advance for any help |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
summing in vba
I dont actually know the column, its going to be done inside the loop. the no
of columns is limited by the no of shifts to be worked in the program. It needs to actually work off the 2 counters, counter 1 = column, counter 2 = row "JLGWhiz" wrote: I might have left a bracket off. If so you will get a run time error. Just add a parenthesis on the end. "Joseph Atie" wrote: im using excel to build a labour list from an ms project data file the job im trying to do is sum column after i populate it using a pair of for loops so the only thing method i have of identifying the files i need to sum is the counters of the loops. I can do it via so more loops and an extra variable. What i want to know is: is there a simpler way to do it? perhaps an expression that i could use something along the lines of: cell.value = "=sum(counter:counter1)" thanks in advance for any help |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
summing in vba
Then post the code you have so someone can help.
"Joseph Atie" wrote: I dont actually know the column, its going to be done inside the loop. the no of columns is limited by the no of shifts to be worked in the program. It needs to actually work off the 2 counters, counter 1 = column, counter 2 = row "JLGWhiz" wrote: I might have left a bracket off. If so you will get a run time error. Just add a parenthesis on the end. "Joseph Atie" wrote: im using excel to build a labour list from an ms project data file the job im trying to do is sum column after i populate it using a pair of for loops so the only thing method i have of identifying the files i need to sum is the counters of the loops. I can do it via so more loops and an extra variable. What i want to know is: is there a simpler way to do it? perhaps an expression that i could use something along the lines of: cell.value = "=sum(counter:counter1)" thanks in advance for any help |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
summing in vba
FWIW: I don't see the need for the 2nd " (the one following F2) Sum(Range("F2":F" "JLGWhiz" wrote: If you know the column that you are putting the data in, for instance, column F, then you could use: Sub addItup() Dim mySum As Double mySum = WorksheetFunction.Sum(Range("F2":F" _ & Range("F65536").End(xlUp).Row) MsgBox mySum End Sub That would give you the sum of the values in column F as a dynamic range, assuming a header row. "Joseph Atie" wrote: im using excel to build a labour list from an ms project data file the job im trying to do is sum column after i populate it using a pair of for loops so the only thing method i have of identifying the files i need to sum is the counters of the loops. I can do it via so more loops and an extra variable. What i want to know is: is there a simpler way to do it? perhaps an expression that i could use something along the lines of: cell.value = "=sum(counter:counter1)" thanks in advance for any help |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Summing | Excel Worksheet Functions | |||
PivotTable and summing/not summing | Excel Discussion (Misc queries) | |||
Summing | Excel Programming | |||
Summing | Excel Programming | |||
Summing | Excel Programming |