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. . |
All times are GMT +1. The time now is 11:33 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com