I have a listing of multiple contracts with the date (mm/dd/yy) each time a delivery was made and I need to find the sum of how many deliveries were made each year for each contract.
I'm assuming I'd need to use a sumifs or sumproduct but not sure how to do so.
Contracts are in range A2:A3390, dates are in range B2:B3390. I have 19 contracts with dates ranging from 2013 to 2018 so need a summary of each contract for each year. I've tried using a pivot table but either can't get the fields to show up at all or can't get it to sum by year per contract.
For example:
Contract Year Sum
Contract1 2013 10
Contract1 2014 75
Contract1 2015 84
... etc.
Contract2 2013 120
Contract2 2014 221
Contract2 2015 192
... etc.
Contract3 2013 45
Contract3 2014 64
... etc.
Thanks in advance.
I'm assuming I'd need to use a sumifs or sumproduct but not sure how to do so.
Contracts are in range A2:A3390, dates are in range B2:B3390. I have 19 contracts with dates ranging from 2013 to 2018 so need a summary of each contract for each year. I've tried using a pivot table but either can't get the fields to show up at all or can't get it to sum by year per contract.
For example:
Contract Year Sum
Contract1 2013 10
Contract1 2014 75
Contract1 2015 84
... etc.
Contract2 2013 120
Contract2 2014 221
Contract2 2015 192
... etc.
Contract3 2013 45
Contract3 2014 64
... etc.
Thanks in advance.