sum of a cell if 2 cells meet a condition

M

Markitos

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
 
A

Aladin Akyurek

=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.
 
M

Markitos

Thanks for your advice, but Im still confused, not sure how E2 plays into
effect here.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top