Sum Data by Calculated value

NHForester

New Member
Joined
Aug 13, 2014
Messages
4
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 TicketF&L Trip TicketScale Slip #DateFyCustomWhite pine - GWhite pine - PHemlockred pine Red Spruce Red Oak Red MapleOther hardwoodHardwood pallet
% of Vol. Harvested124.9%74.9%78.1%77.2%100.0%87.3%57.5%147.0%486.7%
695114238601/19/162016In
695214250101/22/162016Co
695314250601/22/162016Co
69545575101/22/162016King6.0450.915
695514251401/19/162016In
695614252101/22/162016In
695714252801/23/162016In
69585173001/23/162016Beck
695969842301/23/162016In
696069847901/23/162016In
69615571801/25/162016King6.845
696214260801/22/162016In
696314261601/25/162016In
696414263701/25/162016In
69655175201/25/162016Beck
Total volume293.39515.20026.4252.8750.50043.9905.3606.49027.838
# of Loads22222314111481516
Avg. Load1.3220.0681.8882.8750.5003.1420.6700.4331.740
FYCategorySftwdSftwdSftwdSftwdSftwdHdwdHdwdHdwdHdwd
2016
List of Fiscal Years
2017
2019
2021
2023
2024
1900

<colgroup><col><col><col><col span="2"><col><col span="9"></colgroup><tbody>
</tbody>
 

Forum statistics

Threads
1,084,796
Messages
5,379,933
Members
401,633
Latest member
DinnerB0ne

Some videos you may like

This Week's Hot Topics

Top