Spreadsheet: 215059d1361245610-returning-sum-based-on-row-and-column-critera-sumifs-returning-sum-of-criteria-drawn-from-column-and-row
Sheet: P&L

PROFIT AND LOSS
 |  |  | FY08 | FY08 | FY08 | FY08 | FY09 | FY09 | FY09 | FY09 | FY10 | FY10 | FY10 | FY10 | FY11 | FY11 |  |  | FY11 | FY11 |  | FY12 |  | FY12 |  | FY12 | FY12 |  | FY13 | FY13
 |  |  | Sep 07 QTR | Dec 07 QTR | [NAME] QTR | Jun 08 QTR | SEP 08 QTR | DEC 08 QTR | MAR 09 QTR | JUN 09 QTR | SEP 09 QTR | DEC 09 QTR | MAR 10 QTR | JUN 10 QTR | SEP 10 QTR | DEC 10 QTR | Dec 2010 YTD | Mar 2011 YTD | MAR 11 QTR | JUN 11 QTR | EOFY June 2011 | SEP 11 QTR | Dec 2011 YTD | DEC 11 QTR | [NAME] YTD | MAR 12 QTR | JUN 12 QTR | EOFY June 2012 | SEP 12 QTR | DEC 12 QTR | YTD Dec 12
Profit and Loss Report
Sales
 | Tankage Contract | Tankage | 878213.11 | 0 | 1893466.08 | 1825792.68 | 2091069.29 | 2300818.86 | 2590514.439999999 | 4301689.99 | 6319333.32 | 5788377.93 | 1847569.949999999 | 2756218.520000001 | 4193934.09 | 4001587.62 | 8195521.71 | 9682960.13 | 1487438.420000001 | 1782924.909999998 | 11465885.04 | 10300243.78 | 24377987.24 | 14077743.46 | 34535481.48 | 10157494.24 | -293060.3999999985 | 34242421.08 | 1299868.78 | 1893233.34 | 3193102.12
 | Piping Contract | Piping | 3691855.68 | 0 | 2151177.709999999 | 4006617.96 | 5224474.64 | 6219337.52 | 4825133.869999998 | 2369019.030000001 | 3963963.21 | 3420094.05 | 4095546.050000001 | 7275991.159999997 | 679812.74 | 2874026.88 | 3553839.62 | 8755736.34 | 5201896.72 | 29478986.09 | 38234722.43 | 5731513.54 | 9560392.11 | 3828878.569999999 | 16601976.07 | 7041583.960000001 | 12121317.67 | 28723293.74 | 15136608.27 | 5879150.370000001 | 21015758.64
 | Vessel Contract | Vessel | 504397.5 | 0 | 1394035.4 | 1354718.14 | 674872.06 | 94127 | 131516.2 | 391225.4199999999 | 241573 | 162852.5 | 314395.25 | 86301.98999999999 | 561041.11 | 518237.16 | 1079278.27 | 1313172.48 | 233894.21 | 238729.98 | 1551902.46 | 499049.85 | 1135905.85 | 636856.0000000001 | 1243256.55 | 107350.7 | 79600 | 1322856.55 | 1584.5 | 6716 | 8300.5
 | Structural Contract | Structural | 867544.57 | 0 | 2635637.65 | 364952.7799999997 | 208046 | 225210.52 | 196749 | 145319.9 | 178263 | 296542.27 | 7871.449999999953 | 243109.29 | 50300 | 5729162.25 | 5779462.25 | 14165054.74 | 8385592.49 | -13906653.55 | 258401.19 | 10355273.23 | 14989968.33 | 4634695.1 | 16550315.45 | 1560347.119999999 | 1499240.960000001 | 18049556.41 | 1037406.22 | 4765856.760000001 | 5803262.98
 | Labour Income | Other | 63832.9 | 0 | 85229.20000000001 | 4509.999999999993 | 0 | 5424 | -21168 | 0 |  | 259965.3 | 0 | 0 | 18445 | 0 | 18445 | 126534 | 108089 | 31761.5 | 158295.5 | 27219 | 66039 | 38820 | 135790 | 69751 | 69825.07999999999 | 205615.08 | 0 | 37615 | 37615
 | Bending | Other | 0 | 0 | 5520 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  |  |  | 0
 | Sundry Income | Other | 0 | 0 | 0 | 0 | 0 | 0 | 2193.77 | 5024.73 |  |  | 9533 | 0 |  |  | 16122.62 | 39243.18 | 23120.56 | 18956.7 | 58199.88 | 14322.26 | 46056.76 | 31734.5 | 94503.54 | 48446.77999999999 | 30989.37000000001 | 125492.91 | 32106.43 | 12645.51 | 44751.94
 | Fuel Tax Credits | Other | 199639.69 | 0 | 595522.05 | 302036.31 | 215293.67 | 5153.179999999993 | 30229.31 | -188958.1 | -2509.83 | 6477.45 | -68013.38 | 10573.15000000001 | 8111.62 | 8011.000000000001 |  | 0 | 0 | 0 | 0 | 0 | 13440 | 13440 | 25159 | 11719 | 0 | 25159 | 0 | 0 | 0
 | Misc Income | Other | 14651.2 | 0 | -7281.790000000001 | 4587.200000000001 | 16492.68 | 25194.26 | 2609.189999999995 | 8545.060000000005 | 12597.9 | 11634.46 | 9331.38 | 21962.55 | 3413 | 1711.6 | 5124.6 | 5124.6 | 0 | 6375.99 | 11500.59 | 16409.82 | 25679.04 | 9269.220000000001 | 38131.86 | 12452.82 | -175.5500000000029 | 37956.31 | 0 | 0 | 0
 | Total Sales |  | 6220134.650000001 | 0 | 8753306.3 | 7863215.07 | 8430248.34 | 8875265.34 | 7757777.779999997 | 7031866.030000002 | 10713220.6 | 9945943.96 | 6216233.7 | 10394156.66 | 5515057.560000001 | 13132736.51 | 18647794.07 | 34087825.47 | 15440031.4 | 17651081.62 | 51738907.09 | 26944031.48 | 50215468.32999999 | 23271436.84999999 | 69224613.95 | 19009145.62 | 13507737.13 | 82732351.07999998 | 17507574.2 | 12595216.98 | 30102791.18