Spreadsheet: 877800d1724728053-combining-sumifs-and-hlookup-excel_help_sumifs_xlookup
Sheet: Sheet1

Business Stream | SubSet | 2024-01-01 00:00:00 | 2024-02-01 00:00:00 | 2024-03-01 00:00:00 | 2024-04-01 00:00:00 | 2024-05-01 00:00:00 | 2024-06-01 00:00:00 | 2024-07-01 00:00:00 | 2024-08-01 00:00:00 | 2024-09-01 00:00:00 | 2024-10-01 00:00:00 | 2024-11-01 00:00:00 | 2024-12-01 00:00:00 | Full Year P&L | Full Year P&L | BS | 2024-01-01 00:00:00 | 2024-02-01 00:00:00 | 2024-03-01 00:00:00 | 2024-04-01 00:00:00 | 2024-05-01 00:00:00 | 2024-06-01 00:00:00 | 2024-07-01 00:00:00 | 2024-08-01 00:00:00 | 2024-09-01 00:00:00 | 2024-10-01 00:00:00 | 2024-11-01 00:00:00 | 2024-12-01 00:00:00
Apples | Management & Rights Fees | -151250 | -26300 | -320 | -32890.96 | 0 | -876.5 | -154250 |  |  |  |  |  | -365887.46 | -365887.46 |  | -151250 | -177550 | -177870 | -210760.96 | -210760.96 | -211637.46 | -365887.46 | -365887.46 | -365887.46 | -365887.46 | -365887.46 | -365887.46
Apples | Management & Rights Fees | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Apples | Management & Rights Fees | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Apples | Trophies | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Apples | Staff Costs | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Apples | Staff Costs | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Apples | Staff Costs | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Apples | Staff Costs | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Apples | Staff Costs | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Apples | Staff Costs | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Apples | Management & Rights Fees | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Apples | Management & Rights Fees | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Pears | Other | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Pears | Registration & Entry Fees | 0 | 0 | -55770 | -46470 | -8070 | -1740 | -1500 |  |  |  |  |  | -113550 | -113550 |  | 0 | 0 | -55770 | -102240 | -110310 | -112050 | -113550 | -113550 | -113550 | -113550 | -113550 | -113550
Pears | Registration & Entry Fees | 0 | -49874 | -18894 | -101612.5 | -125818.5 | -71083 | -70671.5 |  |  |  |  |  | -437953.5 | -437953.5 |  | 0 | -49874 | -68768 | -170380.5 | -296199 | -367282 | -437953.5 | -437953.5 | -437953.5 | -437953.5 | -437953.5 | -437953.5
Pears | Equipment Sales/Commissions | 0 | -49094.37 | -96976.04 | -184668.5 | -226814.13 | -121865.74 | -144557.61 |  |  |  |  |  | -823976.39 | -823976.39 |  | 0 | -49094.37 | -146070.41 | -330738.91 | -557553.04 | -679418.78 | -823976.39 | -823976.39 | -823976.39 | -823976.39 | -823976.39 | -823976.39
Pears | Clubs, Schools & Instructors | 0 | -3850 | -5850 | -8300 | -7245 | -2550 | -990 |  |  |  |  |  | -28785 | -28785 |  | 0 | -3850 | -9700 | -18000 | -25245 | -27795 | -28785 | -28785 | -28785 | -28785 | -28785 | -28785
Pears | Equipment Sales/Commissions | 0 | -1246.66 | -374.57 | -2330.4 | -765 | -283.31 | -205.41 |  |  |  |  |  | -5205.35 | -5205.35 |  | 0 | -1246.66 | -1621.23 | -3951.63 | -4716.63 | -4999.940000000001 | -5205.35 | -5205.35 | -5205.35 | -5205.35 | -5205.35 | -5205.35
Pears | Partners & Advertising | -50000 | 0 | -13000 | -6000 | 0 | -3750 | 0 |  |  |  |  |  | -72750 | -72750 |  | -50000 | -50000 | -63000 | -69000 | -69000 | -72750 | -72750 | -72750 | -72750 | -72750 | -72750 | -72750
Pears | Other | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Pears | Direct Costs | 0 | 0 | 176075.69 | 73012.78 | 123707.53 | 161673.73 | 151702.64 |  |  |  |  |  | 686172.37 | 686172.37 |  | 0 | 0 | 176075.69 | 249088.47 | 372796 | 534469.73 | 686172.37 | 686172.37 | 686172.37 | 686172.37 | 686172.37 | 686172.37
Pears | Direct Costs | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Pears | Contractors/Consultants | 4909.74 | 4714.74 | 14665.33 | 19157.03 | 34536.83 | 31476.67 | 19225.37 |  |  |  |  |  | 128685.71 | 128685.71 |  | 4909.74 | 9624.48 | 24289.81 | 43446.84 | 77983.67 | 109460.34 | 128685.71 | 128685.71 | 128685.71 | 128685.71 | 128685.71 | 128685.71
Pears | Contractors/Consultants | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Pears | Per Capita Fees | 0 | 0 | 3740 | -3740 | 11983 | 4520 | 2739 |  |  |  |  |  | 19242 | 19242 |  | 0 | 0 | 3740 | 0 | 11983 | 16503 | 19242 | 19242 | 19242 | 19242 | 19242 | 19242
Pears | Bank Charges | 0 | 2406.47 | 3342.89 | 8032.76 | 8105.02 | 4469.35 | 4551.69 |  |  |  |  |  | 30908.18 | 30908.18 |  | 0 | 2406.47 | 5749.36 | 13782.12 | 21887.14 | 26356.49 | 30908.18 | 30908.18 | 30908.18 | 30908.18 | 30908.18 | 30908.18
Pears | Operations & Logistics | 3378.68 | 1837.48 | 3981.39 | 3600.83 | 7205.36 | 7718.83 | 4718.91 |  |  |  |  |  | 32441.48 | 32441.48 |  | 3378.68 | 5216.16 | 9197.55 | 12798.38 | 20003.74 | 27722.57 | 32441.48 | 32441.48 | 32441.48 | 32441.48 | 32441.48 | 32441.48
Pears | Operations & Logistics | 275 | 1315 | 5965.5 | 5392.61 | 9830.11 | 9830.11 | 5317.11 |  |  |  |  |  | 37925.44 | 37925.44 |  | 275 | 1590 | 7555.5 | 12948.11 | 22778.22 | 32608.33 | 37925.44 | 37925.44 | 37925.44 | 37925.44 | 37925.44 | 37925.44
Pears | Operations & Logistics | 0 | 0 | 16750 | 16750 | 33500 | 33500 | 16750 |  |  |  |  |  | 117250 | 117250 |  | 0 | 0 | 16750 | 33500 | 67000 | 100500 | 117250 | 117250 | 117250 | 117250 | 117250 | 117250
Pears | Meeting Costs | 2850 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  | 2850 | 2850 |  | 2850 | 2850 | 2850 | 2850 | 2850 | 2850 | 2850 | 2850 | 2850 | 2850 | 2850 | 2850
Pears | Trophies | 0 | 0 | 1530 | 1030 | 2713.5 | 3045 | 1590 |  |  |  |  |  | 9908.5 | 9908.5 |  | 0 | 0 | 1530 | 2560 | 5273.5 | 8318.5 | 9908.5 | 9908.5 | 9908.5 | 9908.5 | 9908.5 | 9908.5
Pears | Awards, Hospitality & Entertaining | 0 | 0 | 295.4 | 0 | 0 | 0 | 0 |  |  |  |  |  | 295.4 | 295.4 |  | 0 | 0 | 295.4 | 295.4 | 295.4 | 295.4 | 295.4 | 295.4 | 295.4 | 295.4 | 295.4 | 295.4
Pears | Marketing & Promotion | 600 | 600 | 8365 | 14817.3 | 21376.2 | 18537.37 | 15626.39 |  |  |  |  |  | 79922.26 | 79922.26 |  | 600 | 1200 | 9565 | 24382.3 | 45758.5 | 64295.87 | 79922.26 | 79922.26 | 79922.26 | 79922.26 | 79922.26 | 79922.26
Pears | Clothing, Sundries & Consumables | 0 | 0 | 0 | 1263.5 | 813.39 | 1439.9 | 216.25 |  |  |  |  |  | 3733.04 | 3733.04 |  | 0 | 0 | 0 | 1263.5 | 2076.89 | 3516.79 | 3733.04 | 3733.04 | 3733.04 | 3733.04 | 3733.04 | 3733.04
Pears | Staff Costs | 4484.79 | 4484.79 | 4484.79 | 4484.79 | 4484.79 | 4484.79 | 4484.79 |  |  |  |  |  | 31393.53 | 31393.53 |  | 4484.79 | 8969.58 | 13454.37 | 17939.16 | 22423.95 | 26908.74 | 31393.53 | 31393.53 | 31393.53 | 31393.53 | 31393.53 | 31393.53
Pears | Staff Costs | 514.3 | 514.3 | 514.3 | 514.3 | 514.3 | 514.3 | 514.3 |  |  |  |  |  | 3600.1 | 3600.1 |  | 514.3 | 1028.6 | 1542.9 | 2057.2 | 2571.5 | 3085.8 | 3600.1 | 3600.1 | 3600.1 | 3600.1 | 3600.1 | 3600.1
Pears | Staff Costs | 708.12 | 708.12 | 708.12 | 708.12 | 708.12 | 708.12 | 708.12 |  |  |  |  |  | 4956.84 | 4956.84 |  | 708.12 | 1416.24 | 2124.36 | 2832.48 | 3540.6 | 4248.72 | 4956.84 | 4956.84 | 4956.84 | 4956.84 | 4956.84 | 4956.84
Pears | Staff Costs | 20.83 | 20.83 | 20.83 | 20.84 | 20.83 | 20.83 | 20.83 |  |  |  |  |  | 145.82 | 145.82 |  | 20.83 | 41.66 | 62.48999999999999 | 83.33 | 104.16 | 124.99 | 145.82 | 145.82 | 145.82 | 145.82 | 145.82 | 145.82
Pears | Staff Costs | 41.67 | 41.67 | 41.67 | 41.67 | 41.67 | 41.67 | 41.67 |  |  |  |  |  | 291.6900000000001 | 291.6900000000001 |  | 41.67 | 83.34 | 125.01 | 166.68 | 208.35 | 250.02 | 291.6900000000001 | 291.6900000000001 | 291.6900000000001 | 291.6900000000001 | 291.6900000000001 | 291.6900000000001
Pears | Staff Costs | 186.24 | 186.24 | 186.24 | 186.24 | 186.24 | 186.24 | 186.24 |  |  |  |  |  | 1303.68 | 1303.68 |  | 186.24 | 372.48 | 558.72 | 744.96 | 931.2 | 1117.44 | 1303.68 | 1303.68 | 1303.68 | 1303.68 | 1303.68 | 1303.68
Pears | Depreciation | 1719.1 | 1719.1 | 1719.1 | 1719.1 | 1719.1 | 1719.1 | 1719.1 |  |  |  |  |  | 12033.7 | 12033.7 |  | 1719.1 | 3438.2 | 5157.299999999999 | 6876.4 | 8595.5 | 10314.6 | 12033.7 | 12033.7 | 12033.7 | 12033.7 | 12033.7 | 12033.7
Pears | Depreciation | 991.93 | 991.93 | 1026.93 | 1113.45 | 1159.29 | 1159.29 | 1159.29 |  |  |  |  |  | 7602.11 | 7602.11 |  | 991.93 | 1983.86 | 3010.79 | 4124.24 | 5283.53 | 6442.82 | 7602.11 | 7602.11 | 7602.11 | 7602.11 | 7602.11 | 7602.11
Pears | Operations & Logistics |  |  | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Oranges | Management & Rights Fees | 0 | 0 | 0 | -174542.9 | -172095 | 174542.9 | -75000 |  |  |  |  |  | -247095 | -247095 |  | 0 | 0 | 0 | -174542.9 | -346637.9 | -172095 | -247095 | -247095 | -247095 | -247095 | -247095 | -247095
Oranges | Volunteers, Officials & Expenses | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Oranges | Volunteers, Officials & Expenses | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Oranges | FIA Service Charges | 0 | 0 | 0 | 0 | 0 | -174542.9 | 0 |  |  |  |  |  | -174542.9 | -174542.9 |  | 0 | 0 | 0 | 0 | 0 | -174542.9 | -174542.9 | -174542.9 | -174542.9 | -174542.9 | -174542.9 | -174542.9
Oranges | Volunteers & Officials | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Oranges | Volunteers & Officials | 0 | 0 | 0 | 0 | 0 | 0 | 12055.56 |  |  |  |  |  | 12055.56 | 12055.56 |  | 0 | 0 | 0 | 0 | 0 | 0 | 12055.56 | 12055.56 | 12055.56 | 12055.56 | 12055.56 | 12055.56
Oranges | Volunteers, Officials & Expenses | 0 | 0 | 0 | 0 | 0 | 399.71 | 1208.3 |  |  |  |  |  | 1608.01 | 1608.01 |  | 0 | 0 | 0 | 0 | 0 | 399.71 | 1608.01 | 1608.01 | 1608.01 | 1608.01 | 1608.01 | 1608.01
Oranges | Volunteers & Officials | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Oranges | Volunteers & Officials | 0 | 0 | 0 | 0 | 19.56 | 75.84 | 14242.72 |  |  |  |  |  | 14338.12 | 14338.12 |  | 0 | 0 | 0 | 0 | 19.56 | 95.4 | 14338.12 | 14338.12 | 14338.12 | 14338.12 | 14338.12 | 14338.12
Oranges | Volunteers & Officials | 0 | 0 | 0 | 37.44 | 0 | 1380.84 | 0 |  |  |  |  |  | 1418.28 | 1418.28 |  | 0 | 0 | 0 | 37.44 | 37.44 | 1418.28 | 1418.28 | 1418.28 | 1418.28 | 1418.28 | 1418.28 | 1418.28
Oranges | Volunteers & Officials | 0 | 0 | 0 | 0 | 0 | 604.07 | 0 |  |  |  |  |  | 604.07 | 604.07 |  | 0 | 0 | 0 | 0 | 0 | 604.07 | 604.07 | 604.07 | 604.07 | 604.07 | 604.07 | 604.07
Oranges | Volunteers & Officials | 0 | 0 | 0 | 0 | 0 | 0 | 710 |  |  |  |  |  | 710 | 710 |  | 0 | 0 | 0 | 0 | 0 | 0 | 710 | 710 | 710 | 710 | 710 | 710
Oranges | Volunteers & Officials | 0 | 0 | 0 | 0 | 0 | 0 | 17897.6 |  |  |  |  |  | 17897.6 | 17897.6 |  | 0 | 0 | 0 | 0 | 0 | 0 | 17897.6 | 17897.6 | 17897.6 | 17897.6 | 17897.6 | 17897.6
Oranges | Volunteers & Officials | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Oranges | Volunteers & Officials | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0