Below is the chart that I have

column a column b column c column d
ABC Company R1 $100,000.00 R1A
DEF Company R2 $25,000.00 R2B
XYZ Company R1 $1,000.00 R1A

I have a listing of different companys (listed in column A)
I have a listing of different Rate catagories (listed in Column B)
I have their current balances (listed in Column C)
Since the rates are tiered, depending on their balance they fall into a
specific catagory within column B (listed in colmn D) So if their balance
changes column D could change.

I need to get a sum total of all the R1A, R2B and so on. There are a lot
more companies, but this is a good example

Can anyone help. I can pass on more information if needed