help wanted urgent
 

my document is in column A:D.Column a is merchant id.
column b is bin number. column c is cr/dr and column d is
the amount.

I want to write a formula to check if column a, b & c =
the true value that I want and if true, sums D:D.

Example:

column A column b column c column d
00001001 426351 cr 10.00
00001001 405262 cr 10.00
00001002 426351 dr 10.00

I want to write a formula that check if cloumn a =
00001001, b= 426351, c=cr, then sum d:d.


.

help wanted urgent
 

Hi
please stay in your original thread :-)

-----Original Message-----
my document is in column A:D.Column a is merchant id.
column b is bin number. column c is cr/dr and column d
is
the amount.

I want to write a formula to check if column a, b & c =
the true value that I want and if true, sums D:D.

Example:

column A column b column c column d
00001001 426351 cr 10.00
00001001 405262 cr 10.00
00001002 426351 dr 10.00

I want to write a formula that check if cloumn a =
00001001, b= 426351, c=cr, then sum d:d.


.

.

help wanted urgent
 

Hi Daniel

You can use an array formula: =SUM(IF(a1:a3=00001001,IF
(b1:b3=426351,d1:d4,0)))

Then press ctrl+shift+enter




-----Original Message-----
my document is in column A:D.Column a is merchant id.
column b is bin number. column c is cr/dr and column d
is
the amount.

I want to write a formula to check if column a, b & c =
the true value that I want and if true, sums D:D.

Example:

column A column b column c column d
00001001 426351 cr 10.00
00001001 405262 cr 10.00
00001002 426351 dr 10.00

I want to write a formula that check if cloumn a =
00001001, b= 426351, c=cr, then sum d:d.


.

.

help wanted urgent
 

Daniel,



=SUMPRODUCT(--(A1:A100="00001001"),--(B1:B100=426351),--(C1:C100="cr"),D1:D1
00)


--
Regards,
Soo Cheon Jheong
_ _
^¢¯^
--