sum if formula help requested

[Guest]

i'm trying to figure out how to make this formula work. if the account id is
"123" then sum colum "a" and "b" for all numbers in the account. example:
acct debit credit
123 -200
123 +200

so i'm trying to get the formula to read if its account 123 the sum should
be "0"

 

[PCLIVE]

I'm assuming your Account #s are in column A, debits are in column B and
credits are in column C. With that in mind, you might try this:

=SUMIF(A1:A6,123,B1:B4)+SUMIF(A1:A6,123,C1:C4)

HTH,
Paul

 

[Peo Sjoblom]

Another way

=SUMPRODUCT((A1:A4=123)*(B1:C4))

 

[Guest]

=SUMPRODUCT(--(A1:A2=123),(B1:B2+C1:C2))

I'm assuming your Account #s are in column A, debits are in column B and
credits are in column C. With that in mind, you might try this:

=SUMIF(A1:A6,123,B1:B4)+SUMIF(A1:A6,123,C1:C4)

HTH,
Paul

 

[Guest]

thanks, i'll try it out!!

=SUMPRODUCT(--(A1:A2=123),(B1:B2+C1:C2))