Need a formula

[dhstein]

This should be easy - but I'm having trouble with it. I have columns A and B
with data like this:

A B

X 5
X 2
Y 1
X 4
Y 3

I want column C to be the total for the table of the value in A. So column
C should have

11
11
4
11
4

Since wherever there is an X in column A the total of the X's is 11(5+2+4),
and wherever there is a Y in column A the total of the Y's is 4 (1+3). I
would appreciate the formula for column C - thanks for any help on this.

 

[Bernard Liengme]

=SUMIF($B$1:$B$10,A1)
best wishes

 

[Max]

Think of SUMIF ..

Assume data as posted in A1:B1 down
In C1: =SUMIF(A:A,A1,B:B)
Copy down

Saviour the moment? Click YES below.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:25,000 Files:300 Subscribers:70
xdemechanik

 

[dhstein]

Thanks Max and Bernard - I just had a temporary brain freeze - but now it's
all thawed.