Home |
Search |
Today's Posts |
#1
|
|||
|
|||
sum of a cell if 2 cells meet a condition
Hello Everyone- Im stuck please help
Im using Collums A, B, C AND Cell D1 Collum A =Account Collum B=Reference Collum C=dollar amount In cell D1 I would like the sum of Column C if rows with A with a value of 101, and B with a value of 201. Or is it better to have the sum of A and B =302 within a row. In this ledger their will be different accounts if that helps. Well, thanks for your time and help, -Markitos |
#2
|
|||
|
|||
=SUMPRODUCT(--($A$2:$A$100=E2),--($B$2:$B$100=F2),$C$2:$C$100)
where E2 houses an account number of interest like 101 and F2 a reference value like 201. Note that this type of formulas do not admit whole column references like A:A. Markitos wrote: Hello Everyone- Im stuck please help Im using Collums A, B, C AND Cell D1 Collum A =Account Collum B=Reference Collum C=dollar amount In cell D1 I would like the sum of Column C if rows with A with a value of 101, and B with a value of 201. Or is it better to have the sum of A and B =302 within a row. In this ledger their will be different accounts if that helps. Well, thanks for your time and help, -Markitos |
#3
|
|||
|
|||
Thanks for your advice, but Im still confused, not sure how E2 plays into
effect here. "Aladin Akyurek" wrote: =SUMPRODUCT(--($A$2:$A$100=E2),--($B$2:$B$100=F2),$C$2:$C$100) where E2 houses an account number of interest like 101 and F2 a reference value like 201. Note that this type of formulas do not admit whole column references like A:A. Markitos wrote: Hello Everyone- Im stuck please help Im using Collums A, B, C AND Cell D1 Collum A =Account Collum B=Reference Collum C=dollar amount In cell D1 I would like the sum of Column C if rows with A with a value of 101, and B with a value of 201. Or is it better to have the sum of A and B =302 within a row. In this ledger their will be different accounts if that helps. Well, thanks for your time and help, -Markitos |
#4
|
|||
|
|||
E2 and F2 are just two cells you enter the conditions/criteria that must
hold for ranges of interest. If you rather not have these extra cells, try: =SUMPRODUCT(--($A$2:$A$100=101),--($B$2:$B$100=201),$C$2:$C$100) Markitos wrote: Thanks for your advice, but Im still confused, not sure how E2 plays into effect here. "Aladin Akyurek" wrote: =SUMPRODUCT(--($A$2:$A$100=E2),--($B$2:$B$100=F2),$C$2:$C$100) where E2 houses an account number of interest like 101 and F2 a reference value like 201. Note that this type of formulas do not admit whole column references like A:A. Markitos wrote: Hello Everyone- Im stuck please help Im using Collums A, B, C AND Cell D1 Collum A =Account Collum B=Reference Collum C=dollar amount In cell D1 I would like the sum of Column C if rows with A with a value of 101, and B with a value of 201. Or is it better to have the sum of A and B =302 within a row. In this ledger their will be different accounts if that helps. Well, thanks for your time and help, -Markitos |
#5
|
|||
|
|||
Thanks Aladin, I played around with both of the formulas and understand the
1st in terms of my set up and your e2, f2 as being a place for an acc. list , and the 2nd formula makes it even easier because it doesnt req. any links. Thanks so much for your help. "Aladin Akyurek" wrote: E2 and F2 are just two cells you enter the conditions/criteria that must hold for ranges of interest. If you rather not have these extra cells, try: =SUMPRODUCT(--($A$2:$A$100=101),--($B$2:$B$100=201),$C$2:$C$100) Markitos wrote: Thanks for your advice, but Im still confused, not sure how E2 plays into effect here. "Aladin Akyurek" wrote: =SUMPRODUCT(--($A$2:$A$100=E2),--($B$2:$B$100=F2),$C$2:$C$100) where E2 houses an account number of interest like 101 and F2 a reference value like 201. Note that this type of formulas do not admit whole column references like A:A. Markitos wrote: Hello Everyone- Im stuck please help Im using Collums A, B, C AND Cell D1 Collum A =Account Collum B=Reference Collum C=dollar amount In cell D1 I would like the sum of Column C if rows with A with a value of 101, and B with a value of 201. Or is it better to have the sum of A and B =302 within a row. In this ledger their will be different accounts if that helps. Well, thanks for your time and help, -Markitos |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I link many cells to one particular cell? | Excel Discussion (Misc queries) | |||
How do I link many cells to one particular cell? | Excel Discussion (Misc queries) | |||
Convert data of cells to any type: Number, Date&Time, Text | Excel Discussion (Misc queries) | |||
How to add cells wiht the condition of the former cell. | Excel Discussion (Misc queries) | |||
GET.CELL | Excel Worksheet Functions |