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

"Ann" wrote in message
...
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"