Index Match & sumifs question?

[pierre robinson]

So I have 2 sheets.

The first shows a UID, dates when payments were made against that UID & how much was paid.

The second contains the UID & when that UID was bought & sold.

So I want to sum those payments against the UID between the bought and sold dates, between specific date ranges.

Examples below:

Sheet A

Code Date paid Amt
AFTM900061 13/02/2018 380
AFTM900061 20/02/2018 380
AFTM900061 27/02/2018 380
AFTM900061 6/03/2018 380
AFTM900061 13/03/2018 380
AFTM900061 20/03/2018 380
AFTM900061 27/03/2018 380
AFTM900061 3/04/2018 385
AFTM900061 10/04/2018 385
AFTM900061 17/04/2018 385
AFTM900061 24/04/2018 385
AFTM900061 1/05/2018 385
AFTM900061 8/05/2018 385
AFTM900062 13/02/2018 380
AFTM900062 20/02/2018 380
AFTM900062 27/02/2018 380
AFTM900062 6/03/2018 80
AFTM900062 13/03/2018 380
AFTM900062 20/03/2018 380
AFTM900062 27/03/2018 380
AFTM900062 3/04/2018 385
AFTM900062 10/04/2018 385
AFTM900062 17/04/2018 385
AFTM900062 24/04/2018 385
AFTM900062 1/05/2018 385
AFTM900062 8/05/2018 385
AFTM900063 13/02/2018 380
AFTM900063 20/02/2018 380
AFTM900063 27/02/2018 380
AFTM900063 6/03/2018 380
AFTM900063 13/03/2018 380
AFTM900063 20/03/2018 380
AFTM900063 27/03/2018 380

Sheet 2 Code Acquisition Date Sale Date PHSS016325 31/03/2016 17/10/2016 PHSS016518 31/03/2016 28/11/2016 PHSS016519 31/03/2016 28/11/2016 PHSS016326 31/03/2016 24/03/2017 ATUD900030 27/06/2017 23/05/2018 ATUD900031 27/06/2017 23/05/2018 ATUD900032 27/06/2017 23/05/2018 ATUD900033 27/06/2017 23/05/2018 AHSS900039 20/06/2017 23/05/2018 PFTS000064 31/03/2016 23/05/2018 PFTS000065 31/03/2016 23/05/2018 PFTS000066 31/03/2016 23/05/2018 PFTS000067 31/03/2016 23/05/2018 PFTS000068 31/03/2016 23/05/2018 PFTS000069 31/03/2016 23/05/2018 PHSS006008 31/03/2016 23/05/2018 PHSS006009 31/03/2016 23/05/2018 PHSS006590 31/03/2016 23/05/2018 PHSS007675 31/03/2016 23/05/2018 PHSM000402 31/03/2016 23/05/2018 PHSS007676 31/03/2016 23/05/2018 PHSS007677 31/03/2016 23/05/2018 PHSS007686 31/03/2016 23/05/2018 PHSM000403 31/03/2016 3/05/2018 PHSS008436 31/03/2016 23/05/2018 PHSS008876 31/03/2016 23/05/2018 PHSS008877 31/03/2016 23/05/2018 PHSS009586 31/03/2016 23/05/2018 <colgroup><col><col><col></colgroup><tbody> </tbody>

<colgroup><col><col><col></colgroup><tbody>
</tbody>

Solution

Code Date 1 Date 2 Date 3 Date 4 Date 5

Any brilliant ideas?

TIA

 

[Oscar Cronquist]

None of the UID's on the second sheet are not found in the first sheet?

Also, I don't understand the solution?

Solution


Code Date 1 Date 2 Date 3 Date 4 Date 5