From: dd on
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
From: Fred Smith on
Using Sumif, as in:
=sumif(A:A,"a",B:B)

Regards,
Fred

"dd" <dd(a)discussions.microsoft.com> wrote in message
news:5A5CABCE-0153-4E72-A638-8ACD238081FC(a)microsoft.com...
>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