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!!