Sumif total accross columns using an achored reference

[castilian07]

I am looking for a moving total based on a criteria in my table from January through December depending on what month I choose. If I choose February I want it to give me Jan and Feb when I change to March, I want it to give me Jan, Feb, & Mar and so on. I have attached my example. sumif with offset works when only one row matches the criteria. I have several rolls matching the criteria. These formula's work but they are not giving me the ytd on my multiple row "OE" in column G criteria. I am looking for the OE for Jan, Feb, Mar, and so on based on what month I choose.


[TABLE="width: 783"]
<colgroup><col><col><col><col span="5"><col></colgroup><tbody>[TR]
[TD]Basic Criteria using fixed month[/TD]
[TD][/TD]
[TD="colspan: 4"] =SUMIF(G$5:$G19,$G$18,$J$5:$J$19) [/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Moving Monthly Criteria[/TD]
[TD][/TD]
[TD="colspan: 6"]=SUMIF($G$5:$T$20,$H$24,INDEX(G5:T5,0,MATCH(H25,G5:T5,0)))[/TD]
[TD]

[/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="width: 87"]
<tbody>[TR]
[TD="class: xl230, width: 87"][TABLE="width: 847"]
<colgroup><col><col><col><col span="5"><col span="2"></colgroup><tbody>[TR]
[TD]YTD total based on moving monthly criteria and Criteria in column H. Offset is being used to achor the cell reference[/TD]
[TD][/TD]
[TD="colspan: 6"]=SUM(OFFSET(H4,MATCH(G28,H5:H20,0),,,MATCH(G27,H5:T5)))[/TD]
[TD] [/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD][TABLE="width: 1197"]
<colgroup><col><col><col><col><col><col span="5"><col span="5"></colgroup><tbody>[TR]
[TD]4[/TD]
[TD]G[/TD]
[TD]H[/TD]
[TD]I[/TD]
[TD]J[/TD]
[TD]K[/TD]
[TD]L[/TD]
[TD]M[/TD]
[TD]N[/TD]
[TD]O[/TD]
[TD]P[/TD]
[TD]Q[/TD]
[TD]R[/TD]
[TD]S[/TD]
[TD]T[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]Jan-17[/TD]
[TD="align: right"]Feb-17[/TD]
[TD="align: right"]Mar-17[/TD]
[TD="align: right"]Apr-17[/TD]
[TD="align: right"]May-17[/TD]
[TD="align: right"]Jun-17[/TD]
[TD="align: right"]Jul-17[/TD]
[TD="align: right"]Aug-17[/TD]
[TD="align: right"]Sep-17[/TD]
[TD="align: right"]Oct-17[/TD]
[TD="align: right"]Nov-17[/TD]
[TD="align: right"]Dec-17[/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]OE[/TD]
[TD](-) Utilities[/TD]
[TD] (127)[/TD]
[TD] (127)[/TD]
[TD] (127)[/TD]
[TD] (128)[/TD]
[TD] (129)[/TD]
[TD] (129)[/TD]
[TD] (129)[/TD]
[TD] (131)[/TD]
[TD] (132)[/TD]
[TD] (129)[/TD]
[TD] (131)[/TD]
[TD] (132)[/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD][/TD]
[TD](-) Labor Costs[/TD]
[TD] (328)[/TD]
[TD] (328)[/TD]
[TD] (328)[/TD]
[TD] (333)[/TD]
[TD] (335)[/TD]
[TD] (335)[/TD]
[TD] (335)[/TD]
[TD] (340)[/TD]
[TD] (342)[/TD]
[TD] (335)[/TD]
[TD] (340)[/TD]
[TD] (342)[/TD]
[/TR]
[TR]
[TD]8[/TD]
[TD]OE[/TD]
[TD](-) Plant Maintenance[/TD]
[TD] (68)[/TD]
[TD] (68)[/TD]
[TD] (68)[/TD]
[TD] (69)[/TD]
[TD] (69)[/TD]
[TD] (69)[/TD]
[TD] (69)[/TD]
[TD] (70)[/TD]
[TD] (70)[/TD]
[TD] (69)[/TD]
[TD] (70)[/TD]
[TD] (70)[/TD]
[/TR]
[TR]
[TD]9[/TD]
[TD]OE[/TD]
[TD](-) Lease Engine Program[/TD]
[TD] (333)[/TD]
[TD] (333)[/TD]
[TD] - [/TD]
[TD] - [/TD]
[TD] - [/TD]
[TD] (340)[/TD]
[TD] - [/TD]
[TD] - [/TD]
[TD] - [/TD]
[TD] - [/TD]
[TD] - [/TD]
[TD] - [/TD]
[/TR]
[TR]
[TD]10[/TD]
[TD]OE[/TD]
[TD](-) Outside Services[/TD]
[TD] (24)[/TD]
[TD] (24)[/TD]
[TD] (24)[/TD]
[TD] (24)[/TD]
[TD] (24)[/TD]
[TD] (24)[/TD]
[TD] (24)[/TD]
[TD] (25)[/TD]
[TD] (25)[/TD]
[TD] (24)[/TD]
[TD] (25)[/TD]
[TD] (25)[/TD]
[/TR]
[TR]
[TD]11[/TD]
[TD][/TD]
[TD](-) Plant Office & Admin[/TD]
[TD] (27)[/TD]
[TD] (27)[/TD]
[TD] (27)[/TD]
[TD] (28)[/TD]
[TD] (28)[/TD]
[TD] (28)[/TD]
[TD] (28)[/TD]
[TD] (28)[/TD]
[TD] (28)[/TD]
[TD] (28)[/TD]
[TD] (28)[/TD]
[TD] (28)[/TD]
[/TR]
[TR]
[TD]12[/TD]
[TD]OE[/TD]
[TD](-) Chemicals[/TD]
[TD] (26)[/TD]
[TD] (26)[/TD]
[TD] (26)[/TD]
[TD] (27)[/TD]
[TD] (27)[/TD]
[TD] (27)[/TD]
[TD] (27)[/TD]
[TD] (27)[/TD]
[TD] (28)[/TD]
[TD] (27)[/TD]
[TD] (27)[/TD]
[TD] (28)[/TD]
[/TR]
[TR]
[TD]13[/TD]
[TD]OE[/TD]
[TD](-) Other Operations Expenses[/TD]
[TD] (36)[/TD]
[TD] (36)[/TD]
[TD] (36)[/TD]
[TD] (37)[/TD]
[TD] (37)[/TD]
[TD] (37)[/TD]
[TD] (37)[/TD]
[TD] (37)[/TD]
[TD] (38)[/TD]
[TD] (37)[/TD]
[TD] (37)[/TD]
[TD] (38)[/TD]
[/TR]
[TR]
[TD]14[/TD]
[TD]OE[/TD]
[TD](-) Insurance[/TD]
[TD] - [/TD]
[TD] - [/TD]
[TD] - [/TD]
[TD] - [/TD]
[TD] - [/TD]
[TD] (158)[/TD]
[TD] - [/TD]
[TD] - [/TD]
[TD] - [/TD]
[TD] - [/TD]
[TD] - [/TD]
[TD] - [/TD]
[/TR]
[TR]
[TD]15[/TD]
[TD]OE[/TD]
[TD](-) Property Tax[/TD]
[TD] - [/TD]
[TD] - [/TD]
[TD] (137)[/TD]
[TD] (137)[/TD]
[TD] - [/TD]
[TD] - [/TD]
[TD] (137)[/TD]
[TD] (137)[/TD]
[TD] - [/TD]
[TD] (137)[/TD]
[TD] (137)[/TD]
[TD] - [/TD]
[/TR]
[TR]
[TD]16[/TD]
[TD][/TD]
[TD](-) Professional Services[/TD]
[TD] (26)[/TD]
[TD] (26)[/TD]
[TD] (26)[/TD]
[TD] (27)[/TD]
[TD] (27)[/TD]
[TD] (27)[/TD]
[TD] (27)[/TD]
[TD] (27)[/TD]
[TD] (27)[/TD]
[TD] (27)[/TD]
[TD] (27)[/TD]
[TD] (27)[/TD]
[/TR]
[TR]
[TD]17[/TD]
[TD]OE[/TD]
[TD](-) O&M Fee[/TD]
[TD] (63)[/TD]
[TD] (63)[/TD]
[TD] (63)[/TD]
[TD] (64)[/TD]
[TD] (65)[/TD]
[TD] (65)[/TD]
[TD] (65)[/TD]
[TD] (66)[/TD]
[TD] (66)[/TD]
[TD] (65)[/TD]
[TD] (66)[/TD]
[TD] (66)[/TD]
[/TR]
[TR]
[TD]18[/TD]
[TD]OE[/TD]
[TD](-) Management Fees[/TD]
[TD] (69)[/TD]
[TD] (69)[/TD]
[TD] (69)[/TD]
[TD] (70)[/TD]
[TD] (70)[/TD]
[TD] (70)[/TD]
[TD] (70)[/TD]
[TD] (71)[/TD]
[TD] (71)[/TD]
[TD] (70)[/TD]
[TD] (71)[/TD]
[TD] (71)[/TD]
[/TR]
[TR]
[TD]19[/TD]
[TD][/TD]
[TD][/TD]
[TD] (19)[/TD]
[TD] (19)[/TD]
[TD] (19)[/TD]
[TD] (19)[/TD]
[TD] (19)[/TD]
[TD] (19)[/TD]
[TD] (19)[/TD]
[TD] (19)[/TD]
[TD] (20)[/TD]
[TD] (19)[/TD]
[TD] (19)[/TD]
[TD] (20)[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[NiMip]

I think this works, but I might be missing what you mean by the sentence "These formula's work but they are not giving me the ytd on my multiple row "OE" in column G criteria"

Formula is =SUM(IFERROR((G$6:$G19=$G$18)*OFFSET($I$6:$I$19,,,,MATCH($I$2,TEXT($I$5:$T$5,"MMM"),0)),0))
Requires CONTROL+SHIFT+ENTER to work, should see {} appear around the formula if you've done it properly.

[TABLE="class: grid, width: 960"]
<tbody>[TR]
[TD="width: 64"][/TD]
[TD="width: 64"]G[/TD]
[TD="width: 64"]H[/TD]
[TD="width: 64"]I[/TD]
[TD="width: 64"]J[/TD]
[TD="width: 64"]K[/TD]
[TD="width: 64"]L[/TD]
[TD="width: 64"]M[/TD]
[TD="width: 64"]N[/TD]
[TD="width: 64"]O[/TD]
[TD="width: 64"]P[/TD]
[TD="width: 64"]Q[/TD]
[TD="width: 64"]R[/TD]
[TD="width: 64"]S[/TD]
[TD="width: 64"]T[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD][/TD]
[TD]Month:[/TD]
[TD]Jun[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD][/TD]
[TD]Result:[/TD]
[TD]-3938[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]Jan-17[/TD]
[TD="align: right"]Feb-17[/TD]
[TD="align: right"]Mar-17[/TD]
[TD="align: right"]Apr-17[/TD]
[TD="align: right"]May-17[/TD]
[TD="align: right"]Jun-17[/TD]
[TD="align: right"]Jul-17[/TD]
[TD="align: right"]Aug-17[/TD]
[TD="align: right"]Sep-17[/TD]
[TD="align: right"]Oct-17[/TD]
[TD="align: right"]Nov-17[/TD]
[TD="align: right"]Dec-17[/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]OE[/TD]
[TD](-) Utilities[/TD]
[TD="align: right"]-127[/TD]
[TD="align: right"]-127[/TD]
[TD="align: right"]-127[/TD]
[TD="align: right"]-128[/TD]
[TD="align: right"]-129[/TD]
[TD="align: right"]-129[/TD]
[TD="align: right"]-129[/TD]
[TD="align: right"]-131[/TD]
[TD="align: right"]-132[/TD]
[TD="align: right"]-129[/TD]
[TD="align: right"]-131[/TD]
[TD="align: right"]-132[/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD][/TD]
[TD](-) Labor Costs[/TD]
[TD="align: right"]-328[/TD]
[TD="align: right"]-328[/TD]
[TD="align: right"]-328[/TD]
[TD="align: right"]-333[/TD]
[TD="align: right"]-335[/TD]
[TD="align: right"]-335[/TD]
[TD="align: right"]-335[/TD]
[TD="align: right"]-340[/TD]
[TD="align: right"]-342[/TD]
[TD="align: right"]-335[/TD]
[TD="align: right"]-340[/TD]
[TD="align: right"]-342[/TD]
[/TR]
[TR]
[TD]8[/TD]
[TD]OE[/TD]
[TD](-) Plant Maintenance[/TD]
[TD="align: right"]-68[/TD]
[TD="align: right"]-68[/TD]
[TD="align: right"]-68[/TD]
[TD="align: right"]-69[/TD]
[TD="align: right"]-69[/TD]
[TD="align: right"]-69[/TD]
[TD="align: right"]-69[/TD]
[TD="align: right"]-70[/TD]
[TD="align: right"]-70[/TD]
[TD="align: right"]-69[/TD]
[TD="align: right"]-70[/TD]
[TD="align: right"]-70[/TD]
[/TR]
[TR]
[TD]9[/TD]
[TD]OE[/TD]
[TD](-) Lease Engine Program[/TD]
[TD="align: right"]-333[/TD]
[TD="align: right"]-333[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD="align: right"]-340[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[/TR]
[TR]
[TD]10[/TD]
[TD]OE[/TD]
[TD](-) Outside Services[/TD]
[TD="align: right"]-24[/TD]
[TD="align: right"]-24[/TD]
[TD="align: right"]-24[/TD]
[TD="align: right"]-24[/TD]
[TD="align: right"]-24[/TD]
[TD="align: right"]-24[/TD]
[TD="align: right"]-24[/TD]
[TD="align: right"]-25[/TD]
[TD="align: right"]-25[/TD]
[TD="align: right"]-24[/TD]
[TD="align: right"]-25[/TD]
[TD="align: right"]-25[/TD]
[/TR]
[TR]
[TD]11[/TD]
[TD][/TD]
[TD](-) Plant Office & Admin[/TD]
[TD="align: right"]-27[/TD]
[TD="align: right"]-27[/TD]
[TD="align: right"]-27[/TD]
[TD="align: right"]-28[/TD]
[TD="align: right"]-28[/TD]
[TD="align: right"]-28[/TD]
[TD="align: right"]-28[/TD]
[TD="align: right"]-28[/TD]
[TD="align: right"]-28[/TD]
[TD="align: right"]-28[/TD]
[TD="align: right"]-28[/TD]
[TD="align: right"]-28[/TD]
[/TR]
[TR]
[TD]12[/TD]
[TD]OE[/TD]
[TD](-) Chemicals[/TD]
[TD="align: right"]-26[/TD]
[TD="align: right"]-26[/TD]
[TD="align: right"]-26[/TD]
[TD="align: right"]-27[/TD]
[TD="align: right"]-27[/TD]
[TD="align: right"]-27[/TD]
[TD="align: right"]-27[/TD]
[TD="align: right"]-27[/TD]
[TD="align: right"]-28[/TD]
[TD="align: right"]-27[/TD]
[TD="align: right"]-27[/TD]
[TD="align: right"]-28[/TD]
[/TR]
[TR]
[TD]13[/TD]
[TD]OE[/TD]
[TD](-) Other Operations Expenses[/TD]
[TD="align: right"]-36[/TD]
[TD="align: right"]-36[/TD]
[TD="align: right"]-36[/TD]
[TD="align: right"]-37[/TD]
[TD="align: right"]-37[/TD]
[TD="align: right"]-37[/TD]
[TD="align: right"]-37[/TD]
[TD="align: right"]-37[/TD]
[TD="align: right"]-38[/TD]
[TD="align: right"]-37[/TD]
[TD="align: right"]-37[/TD]
[TD="align: right"]-38[/TD]
[/TR]
[TR]
[TD]14[/TD]
[TD]OE[/TD]
[TD](-) Insurance[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD="align: right"]-158[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[/TR]
[TR]
[TD]15[/TD]
[TD]OE[/TD]
[TD](-) Property Tax[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD="align: right"]-137[/TD]
[TD="align: right"]-137[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD="align: right"]-137[/TD]
[TD="align: right"]-137[/TD]
[TD]-[/TD]
[TD="align: right"]-137[/TD]
[TD="align: right"]-137[/TD]
[TD]-[/TD]
[/TR]
[TR]
[TD]16[/TD]
[TD][/TD]
[TD](-) Professional Services[/TD]
[TD="align: right"]-26[/TD]
[TD="align: right"]-26[/TD]
[TD="align: right"]-26[/TD]
[TD="align: right"]-27[/TD]
[TD="align: right"]-27[/TD]
[TD="align: right"]-27[/TD]
[TD="align: right"]-27[/TD]
[TD="align: right"]-27[/TD]
[TD="align: right"]-27[/TD]
[TD="align: right"]-27[/TD]
[TD="align: right"]-27[/TD]
[TD="align: right"]-27[/TD]
[/TR]
[TR]
[TD]17[/TD]
[TD]OE[/TD]
[TD](-) O&M Fee[/TD]
[TD="align: right"]-63[/TD]
[TD="align: right"]-63[/TD]
[TD="align: right"]-63[/TD]
[TD="align: right"]-64[/TD]
[TD="align: right"]-65[/TD]
[TD="align: right"]-65[/TD]
[TD="align: right"]-65[/TD]
[TD="align: right"]-66[/TD]
[TD="align: right"]-66[/TD]
[TD="align: right"]-65[/TD]
[TD="align: right"]-66[/TD]
[TD="align: right"]-66[/TD]
[/TR]
[TR]
[TD]18[/TD]
[TD]OE[/TD]
[TD](-) Management Fees[/TD]
[TD="align: right"]-69[/TD]
[TD="align: right"]-69[/TD]
[TD="align: right"]-69[/TD]
[TD="align: right"]-70[/TD]
[TD="align: right"]-70[/TD]
[TD="align: right"]-70[/TD]
[TD="align: right"]-70[/TD]
[TD="align: right"]-71[/TD]
[TD="align: right"]-71[/TD]
[TD="align: right"]-70[/TD]
[TD="align: right"]-71[/TD]
[TD="align: right"]-71[/TD]
[/TR]
[TR]
[TD]19[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]-19[/TD]
[TD="align: right"]-19[/TD]
[TD="align: right"]-19[/TD]
[TD="align: right"]-19[/TD]
[TD="align: right"]-19[/TD]
[TD="align: right"]-19[/TD]
[TD="align: right"]-19[/TD]
[TD="align: right"]-19[/TD]
[TD="align: right"]-20[/TD]
[TD="align: right"]-19[/TD]
[TD="align: right"]-19[/TD]
[TD="align: right"]-20[/TD]
[/TR]
</tbody>[/TABLE]

 

[Nishant94]

Do you want something like this:

Unknown
	G	H	I	J	K	L	M	N	O	P	Q	R	S	T
1		Month:	Jun
2		Result:	-3938
3
4
5			Jan-17	Feb-17	Mar-17	Apr-17	May-17	Jun-17	Jul-17	Aug-17	Sep-17	Oct-17	Nov-17	Dec-17
6	OE	(-) Utilities	-127	-127	-127	-128	-129	-129	-129	-131	-132	-129	-131	-132
7		(-) Labor Costs	-328	-328	-328	-333	-335	-335	-335	-340	-342	-335	-340	-342
8	OE	(-) Plant Maintenance	-68	-68	-68	-69	-69	-69	-69	-70	-70	-69	-70	-70
9	OE	(-) Lease Engine Program	-333	-333	0	0	0	-340	0	0	0	0	0	0
10	OE	(-) Outside Services	-24	-24	-24	-24	-24	-24	-24	-25	-25	-24	-25	-25
11		(-) Plant Office & Admin	-27	-27	-27	-28	-28	-28	-28	-28	-28	-28	-28	-28
12	OE	(-) Chemicals	-26	-26	-26	-27	-27	-27	-27	-27	-28	-27	-27	-28
13	OE	(-) Other Operations Expenses	-36	-36	-36	-37	-37	-37	-37	-37	-38	-37	-37	-38
14	OE	(-) Insurance	0	0	0	0	0	-158	0	0	0	0	0	0
15	OE	(-) Property Tax	0	0	-137	-137	0	0	-137	-137	0	-137	-137	0
16		(-) Professional Services	-26	-26	-26	-27	-27	-27	-27	-27	-27	-27	-27	-27
17	OE	(-) O&M Fee	-63	-63	-63	-64	-65	-65	-65	-66	-66	-65	-66	-66
18	OE	(-) Management Fees	-69	-69	-69	-70	-70	-70	-70	-71	-71	-70	-71	-71
19			-19	-19	-19	-19	-19	-19	-19	-19	-20	-19	-19	-20
Sheet16

Cell Formulas
Range	Formula
I2	=SUMPRODUCT((G6:G19="OE")*(I6:INDEX(I19:T19,MATCH(DATEVALUE(1&I1&2017),I5:T5,0))))

 

[castilian07]

Wow, It's amazing, thank you very much. I would have never thought of the I6: semicolon. Index piece: I'm curious why it works? Thanks so much again. This will make life easier.

 

[castilian07]

Thanks NiMip, I am doing something wrong. I keep getting the 0 indicating there is an error. The match function works in the offset formula as it results 6 columns. I did not get the{} brackets arround the formula. I will keep trying.

 

[NiMip]

The solution from Nishant94 looks pretty suave anyway, so I wouldn't stress! But the issue would be the control+shift+enter. When you put in the formula, instead of just pressing enter you have to press control, shift and enter all together.