I work with a bunch of foresters that are baffled by Pivot Tables. We use a spreadsheet to track harvested sawlog volumes. There can be up to 400 loads entered; when a load is entered a Date is entered which calculates a Fiscal Year. I used CSE formula to generate a list of Fiscal Years. I would like to Automatically sum volumes by using my list of Fiscal Years. Since Fiscal years will change I cant use Sumif because I can't use a cell reference for the criteria. Any suggestions? I am not a coder and but OK with Functions.

Below will give you an idea of data. Any help will be much appreciated.

Thanks

Shaun
NH Div. of Forests & Lands

Property: William Thomas SF Project #: P2-425
Other Trip Ticket F&L Trip Ticket Scale Slip # Date Fy Custom White pine - G White pine - P Hemlock red pine Red Spruce Red Oak Red Maple Other hardwood Hardwood pallet
% of Vol. Harvested 124.9% 74.9% 78.1% 77.2% 100.0% 87.3% 57.5% 147.0% 486.7%
6951 142386 01/19/16 2016 In
6952 142501 01/22/16 2016 Co
6953 142506 01/22/16 2016 Co
6954 55751 01/22/16 2016 King 6.045 0.915
6955 142514 01/19/16 2016 In
6956 142521 01/22/16 2016 In
6957 142528 01/23/16 2016 In
6958 51730 01/23/16 2016 Beck
6959 698423 01/23/16 2016 In
6960 698479 01/23/16 2016 In
6961 55718 01/25/16 2016 King 6.845
6962 142608 01/22/16 2016 In
6963 142616 01/25/16 2016 In
6964 142637 01/25/16 2016 In
6965 51752 01/25/16 2016 Beck
Total volume 293.395 15.200 26.425 2.875 0.500 43.990 5.360 6.490 27.838
# of Loads 222 223 14 1 1 14 8 15 16
Avg. Load 1.322 0.068 1.888 2.875 0.500 3.142 0.670 0.433 1.740
FY Category Sftwd Sftwd Sftwd Sftwd Sftwd Hdwd Hdwd Hdwd Hdwd
2016
List of Fiscal Years 2017
2019
2021
2023
2024
1900