ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   help urgent (https://www.excelbanter.com/excel-programming/305282-help-urgent.html)

Daniel Macgaw

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.



rank Kabel

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.


.



All times are GMT +1. The time now is 11:33 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com