ExcelBanter - totaling $$

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - totaling $$ (https://www.excelbanter.com/excel-discussion-misc-queries/252184-totaling-%24%24.html)

totaling $$

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

Fred Smith[_4_]

totaling $$

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

All times are GMT +1. The time now is 11:44 AM.