Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
I need to find the sum
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
I need to find the sum
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 ...... "John" wrote: 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
I need to find the sum
You want a "Sum total for all R1A, R2B..." ?
You want to know how many of each: =COUNTIF(D:D,"R1A") You want to sum column C for each different D code? =SUMIF(D: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 "John" wrote in message ... 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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
I need to find the sum
Perfect. Thank you very much
"Bernard Liengme" wrote: You want a "Sum total for all R1A, R2B..." ? You want to know how many of each: =COUNTIF(D:D,"R1A") You want to sum column C for each different D code? =SUMIF(D: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 "John" wrote in message ... 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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
I need to find the sum
Hi,
If answer was helpful please say yes, thank you "John" wrote: Perfect. Thank you very much "Bernard Liengme" wrote: You want a "Sum total for all R1A, R2B..." ? You want to know how many of each: =COUNTIF(D:D,"R1A") You want to sum column C for each different D code? =SUMIF(D: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 "John" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find First Non blank cell than find column header and return that value | Excel Worksheet Functions | |||
where to put results of find operation in find and replace functio | Excel Worksheet Functions | |||
Despite data existing in Excel 2002 spreadsheet Find doesn't find | Excel Discussion (Misc queries) | |||
'find' somtimes can't find numbers. I folowd the 'help' instructi. | Excel Worksheet Functions | |||
How do I find a file/spreadsheet that Excel says is Already open but I can't find it? | Excel Discussion (Misc queries) |