help 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 urgent
 

Hi
see your other post
P.S.: please don't multipost

-----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 urgent
 

Daniel
Use SUMPRODUCT eg:
=SUMPRODUCT((A1:A50="00001001")*(B1:B50=426351)*(C 1:C50="cr")*(D1:D50)

PS: assuming column A is text formatted otherwise remove apostrophees (")

HTH
Cordially
Pascal

"Daniel Macgaw" a écrit dans le
message de ...
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 urgent
 

STILL NOT WORKING.
-----Original Message-----
Daniel
Use SUMPRODUCT eg:
=SUMPRODUCT((A1:A50="00001001")*(B1:B50=426351) *
(C1:C50="cr")*(D1:D50)

PS: assuming column A is text formatted otherwise remove
apostrophees (")

HTH
Cordially
Pascal

"Daniel Macgaw" a
écrit dans le
message de ...
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 urgent
 

Hi Daniel
to make it possible for us to identify the error please:
- post the EXACT formula used by you
- Describe what EXACTLY does not work (e.g. error message,
wrong result, etc.)


-----Original Message-----
STILL NOT WORKING.
-----Original Message-----
Daniel
Use SUMPRODUCT eg:
=SUMPRODUCT((A1:A50="00001001")*(B1:B50=426351 )*
(C1:C50="cr")*(D1:D50)

PS: assuming column A is text formatted otherwise remove
apostrophees (")

HTH
Cordially
Pascal

"Daniel Macgaw" a
écrit dans le
message de ...
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.




.

.