how to detect characters and add columns

[pvboston]

Hi folks,

I have some data that I need to parse and sum up,
I have 4 columns of data - A, B, C, D

A B C D
abc 9 0.1 0.2
abc 9 0.1 0.2
xyz 8 0.3 0.3
xyz 8 0.3 0.3
xyz 8 0.3 0.3

I want Excel to go thru data in the column "A",
detect when the character changes (abc to xyz),
give me the sum of all other rows/columns for that
char, for eg - abc it will be: 9+9+0.1+0.1+0.2+0.2

how do I go about writing a macro/function for this?

Thanks a lot for any help on this.

pvboston

[rylo]

Hi

Try

Please Login or Register  to view this content.

rylo