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

=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

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

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

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