Using Sumif, as in:
=sumif(A:A,"a",B:B)

Regards,
Fred

"dd" wrote in message
...
I have one column with a,b,c,d rankings
I have another column with related $ values
How can I add sum the $$ values related to all of the a,b,c,d separately