pandres2002
10-01-2014, 06:59 AM
I am completely new to VBA, and I have limit expertise in Excel. So I need help!!!
I have three columns the first two are zones (integers), and the third is the value I want to cumulatively sum.
This are the first few values:
zoneA zoneB Values
row1 1 2 55
row2 1 2 13
row3 1 3 11
row4 1 4 2
row5 1 4 12
What I need, is to to sum the values of the third column (values) when the values of the first two columns (zone A, zone B) are the same. In the example, the results should be:
1 2 68
1 3 11
1 4 14
I need it to be presented in an excel worksheet as a result.
Thanks!!
I have three columns the first two are zones (integers), and the third is the value I want to cumulatively sum.
This are the first few values:
zoneA zoneB Values
row1 1 2 55
row2 1 2 13
row3 1 3 11
row4 1 4 2
row5 1 4 12
What I need, is to to sum the values of the third column (values) when the values of the first two columns (zone A, zone B) are the same. In the example, the results should be:
1 2 68
1 3 11
1 4 14
I need it to be presented in an excel worksheet as a result.
Thanks!!