Complex sum

[Greshter]

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

 

[Guest]

hi,

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

hth
regards from Brazil
Marcelo

"Greshter" escreveu:

 

[Greshter]

Hi Marcelo

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

Cheers from New Zealand,
Greshter

 

[Guest]

you also can use sumif

regards

"Greshter" escreveu:

 

[Guest]

thanks for the feedback



"Greshter" escreveu: