Remember Me?

#1
June 28th 13, 05:04 AM posted to microsoft.public.excel.newusers
 external usenet poster First recorded activity by ExcelBanter: Sep 2012 Posts: 13
Help with column accumulation needed

Column A has a set of random values.
Many of them are repeated but are not consecutive to each other.
Column B has a value for each column A entry.
For example
a 5
c 6
b 3
d 1
a 2
b 4
f 2
g 5
c 3

I want to total all the values in col b for each value in col a.
The result should show A = 7, B = 7, C = 9, D = 1, F = 2 & G = 5.

I hope this is self explanatory.
Thanks for any and all help.

#2
June 30th 13, 10:42 AM
 Senior Member First recorded activity by ExcelBanter: Mar 2012 Posts: 663

Quote:
 Originally Posted by Column A has a set of random values. Many of them are repeated but are not consecutive to each other. Column B has a value for each column A entry. For example a 5 c 6 b 3 d 1 a 2 b 4 f 2 g 5 c 3 I want to total all the values in col b for each value in col a. The result should show A = 7, B = 7, C = 9, D = 1, F = 2 & G = 5. I hope this is self explanatory. Thanks for any and all help.
You could use a pivot table to do this, or for a formula based solution, if you have A in cell F1, B in F2, C in F3 etc. then put =SUMIF(A:A,F1,B:B) in cell G1 and copy down.

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post Tom Excel Discussion (Misc queries) 1 December 17th 07 05:47 PM Clueless Excel Worksheet Functions 3 January 9th 07 07:18 AM Vicki Excel Programming 5 October 5th 06 04:50 PM VR Excel Worksheet Functions 3 September 28th 06 08:05 PM Paul Excel Worksheet Functions 1 April 22nd 05 11:32 PM

All times are GMT +1. The time now is 04:03 AM.