sum if formula help requested
 

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"

sum if formula help requested
 

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"

sum if formula help requested
 

Another way

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


--
Regards,

Peo Sjoblom


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

sum if formula help requested
 

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

"PCLIVE" wrote:

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"

sum if formula help requested
 

thanks, i'll try it out!!

"Toppers" wrote:

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

"PCLIVE" wrote:

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"