sum if formula help requested

A

Ann

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"
 
P

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
 
T

Toppers

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

PCLIVE said:
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
Click to expand...
 
Top