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
|