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