if 1 cell is true then use another cell value in its row

T

the_top_man

i have a table, i have a column of cells containing the values 'k' or
's' or 't' or 'r'
i then have a column of cells containing a sum of money representing a
figure 'k' has achieved on that particular row of cells etc.
i need to add the number into a seperate cell that will have the total
value of all of 'k' sums of money

sorry if thats confusing, its kinda hard to explain
 
D

Dav

If the letters are in column A and the values are in column B

sumif(a2:a100,"A",b2:b100)

Regards

Dav
 
C

CLR

Check out Data > SubTotals..........it will give you a nice looking report of
such information......

Vaya con Dios,
Chuck, CABGx3
 
Top