I have 1 spread sheet that records the date of a transaction, the type and $ amount of the transaction and another where I balance the transactions against a bank statment and our cash application system
I wrote an argument that compares a control date and transaction type in the balancing sheet with the date and type in the detail sheet. if they are a match the argument brings back the $ amount of the transaction.

=IF((AND(Date='AMEX-MC-VISA'!$D21,Amex='AMEX-MC-VISA'!$B21)),'AMEX-MC-VISA'!$F21,0)

How do i modify this to bring back the $ amounts and transaction types for a range of sequential control dates i:e: 5/1 thru 5/7 rather than just a single date as the formula above does?

jayatwork