I need to find the sum

[John]

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

 

[Eduardo]

Hi John,
I supposed that in column E1 you will have R1A, in F1 R2B, so in E2 enter
the formula as follow

=SUMPRODUCT(--(e1=$d:$d),--$c:$c) if you are using excel 2007 if not replace
for

=SUMPRODUCT(--(e1=$d1:$d2000),--$c1:$c2000)
And copy to F2, F3 ......

 

[Bernard Liengme]

You want a "Sum total for all R1A, R2B..." ?

You want to know how many of each:
=COUNTIF(D,"R1A")

You want to sum column C for each different D code?
=SUMIF(D, "R1A",C:C)

Of course in each case "R1A" could be replaced by a cell reference

best wishes

 

[John]

Perfect. Thank you very much

You want a "Sum total for all R1A, R2B..." ?

You want to know how many of each:
=COUNTIF(D,"R1A")

You want to sum column C for each different D code?
=SUMIF(D, "R1A",C:C)

Of course in each case "R1A" could be replaced by a cell reference

best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

 

[Eduardo]

Hi,
If answer was helpful please say yes, thank you