Complex sum
 

Hi

I am trying to do a do a series of sums hopefully using a nice little
macro. The data I have looks a bit like this:

Cad POS Road Marine
1 45.5 76
2 56 65 44
3 73 76
3 34 55
4 56 2 5
5 7756 567
5 6556 2 32
5 88 8745
6 653 478
6 33 487 54
7 227 884
8 727 48748
8 78 48 42
8 546 4484 35
8 546 4848 555
9 354 4856
10 563 65

What I want to do is basically sum up the values for each Cad number
e.g. Cad 3 would have POS = 73 + 34 and Road = 76 + 55 and Cad 6 would
have POS = 653 + 33 and Road = 478 + 487 and Marine = 54. Then spit the
values out in four new columns with a unique Cad number in the first
column, POS value, Road value, Marine value.

As I have a fair number of these records I really don't want to do any
manual summing. I'm sure it doesn't seem particularly complicated for
someone who is in the know.

Any help would be really appreciated.

Cheers,
Greshter

Complex sum
 

hi,

try DATA | Subtotals | and choose to sum POS, Road and Marine always the cad
change

hth
regards from Brazil
Marcelo

"Greshter" escreveu:

Hi

I am trying to do a do a series of sums hopefully using a nice little
macro. The data I have looks a bit like this:

Cad POS Road Marine
1 45.5 76
2 56 65 44
3 73 76
3 34 55
4 56 2 5
5 7756 567
5 6556 2 32
5 88 8745
6 653 478
6 33 487 54
7 227 884
8 727 48748
8 78 48 42
8 546 4484 35
8 546 4848 555
9 354 4856
10 563 65

What I want to do is basically sum up the values for each Cad number
e.g. Cad 3 would have POS = 73 + 34 and Road = 76 + 55 and Cad 6 would
have POS = 653 + 33 and Road = 478 + 487 and Marine = 54. Then spit the
values out in four new columns with a unique Cad number in the first
column, POS value, Road value, Marine value.

As I have a fair number of these records I really don't want to do any
manual summing. I'm sure it doesn't seem particularly complicated for
someone who is in the know.

Any help would be really appreciated.

Cheers,
Greshter

Complex sum
 

Hi Marcelo

That's just the ticket! You've just shown me a whole new Excel world.

Cheers from New Zealand,
Greshter

Marcelo wrote:

hi,

try DATA | Subtotals | and choose to sum POS, Road and Marine always the cad
change

hth
regards from Brazil
Marcelo

"Greshter" escreveu:

Hi

I am trying to do a do a series of sums hopefully using a nice little
macro. The data I have looks a bit like this:

Cad POS Road Marine
1 45.5 76
2 56 65 44
3 73 76
3 34 55
4 56 2 5
5 7756 567
5 6556 2 32
5 88 8745
6 653 478
6 33 487 54
7 227 884
8 727 48748
8 78 48 42
8 546 4484 35
8 546 4848 555
9 354 4856
10 563 65

What I want to do is basically sum up the values for each Cad number
e.g. Cad 3 would have POS = 73 + 34 and Road = 76 + 55 and Cad 6 would
have POS = 653 + 33 and Road = 478 + 487 and Marine = 54. Then spit the
values out in four new columns with a unique Cad number in the first
column, POS value, Road value, Marine value.

As I have a fair number of these records I really don't want to do any
manual summing. I'm sure it doesn't seem particularly complicated for
someone who is in the know.

Any help would be really appreciated.

Cheers,
Greshter

Complex sum
 

you also can use sumif

regards

"Greshter" escreveu:

Hi

I am trying to do a do a series of sums hopefully using a nice little
macro. The data I have looks a bit like this:

Cad POS Road Marine
1 45.5 76
2 56 65 44
3 73 76
3 34 55
4 56 2 5
5 7756 567
5 6556 2 32
5 88 8745
6 653 478
6 33 487 54
7 227 884
8 727 48748
8 78 48 42
8 546 4484 35
8 546 4848 555
9 354 4856
10 563 65

What I want to do is basically sum up the values for each Cad number
e.g. Cad 3 would have POS = 73 + 34 and Road = 76 + 55 and Cad 6 would
have POS = 653 + 33 and Road = 478 + 487 and Marine = 54. Then spit the
values out in four new columns with a unique Cad number in the first
column, POS value, Road value, Marine value.

As I have a fair number of these records I really don't want to do any
manual summing. I'm sure it doesn't seem particularly complicated for
someone who is in the know.

Any help would be really appreciated.

Cheers,
Greshter

Complex sum
 

thanks for the feedback



"Greshter" escreveu:

Hi

I am trying to do a do a series of sums hopefully using a nice little
macro. The data I have looks a bit like this:

Cad POS Road Marine
1 45.5 76
2 56 65 44
3 73 76
3 34 55
4 56 2 5
5 7756 567
5 6556 2 32
5 88 8745
6 653 478
6 33 487 54
7 227 884
8 727 48748
8 78 48 42
8 546 4484 35
8 546 4848 555
9 354 4856
10 563 65

What I want to do is basically sum up the values for each Cad number
e.g. Cad 3 would have POS = 73 + 34 and Road = 76 + 55 and Cad 6 would
have POS = 653 + 33 and Road = 478 + 487 and Marine = 54. Then spit the
values out in four new columns with a unique Cad number in the first
column, POS value, Road value, Marine value.

As I have a fair number of these records I really don't want to do any
manual summing. I'm sure it doesn't seem particularly complicated for
someone who is in the know.

Any help would be really appreciated.

Cheers,
Greshter