I need to find the sum

  • Thread starter Thread starter John
  • Start date Start date
J

John

Below is the chart that I have

column a column b column c column d

ABC Company R1 $100,000.00 R1A
123 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
 
Excel? You need to post in an Excel newsgroup.
--
Tom [Pepper] Willett
Microsoft MVP - FrontPage
---------------------------
: Below is the chart that I have
:
: column a column b column c column d
:
: ABC Company R1 $100,000.00 R1A
: 123 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
 
Back
Top