kurt0101
04-14-2009, 07:27 PM
Hi. I have some data that is organized like so:
(just an example)
A2009 5
A2009 10
B2009 15
C2009 18
C2009 23
D2009 25
D2009 27
etc.
The point is that there are two columns
the first column has a letter followed by a 4 digit number.
how many A2009's, B2009's etc appear in a row(repeat) is variable.
the second column has a number from 0->infinity
What I need to do is add the numbers in column two for EACH letter/4 digit number in column one.
So the sum for A2009 would be 15(10+5)
the sum for B2009 would be 15
the sum for C2009 would be 41 (18+23)
the sum for D2009 would be 52 (25+27)
So of course I do not want to do this by hand because I may have many thousands of rows ranging from A2009->Z2009 in column A
But I only need the sum for A2009, B2009 etc individually.
Hope this makes sense.
I have attached a file if my explanation does not make sense.
Thank you!
(just an example)
A2009 5
A2009 10
B2009 15
C2009 18
C2009 23
D2009 25
D2009 27
etc.
The point is that there are two columns
the first column has a letter followed by a 4 digit number.
how many A2009's, B2009's etc appear in a row(repeat) is variable.
the second column has a number from 0->infinity
What I need to do is add the numbers in column two for EACH letter/4 digit number in column one.
So the sum for A2009 would be 15(10+5)
the sum for B2009 would be 15
the sum for C2009 would be 41 (18+23)
the sum for D2009 would be 52 (25+27)
So of course I do not want to do this by hand because I may have many thousands of rows ranging from A2009->Z2009 in column A
But I only need the sum for A2009, B2009 etc individually.
Hope this makes sense.
I have attached a file if my explanation does not make sense.
Thank you!