Thread: help urgent
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Frank Kabel Frank Kabel is offline
external usenet poster
 
Posts: 3,885
Default 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.


.