castilian07
New Member
- Joined
- Dec 19, 2017
- Messages
- 7
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.
<colgroup><col><col><col><col span="5"><col></colgroup><tbody>
</tbody>
<tbody>
</tbody>
<tbody>
</tbody>
Basic Criteria using fixed month | =SUMIF(G$5:$G19,$G$18,$J$5:$J$19) | ||||
Moving Monthly Criteria | =SUMIF($G$5:$T$20,$H$24,INDEX(G5:T5,0,MATCH(H25,G5:T5,0))) | |
<colgroup><col><col><col><col span="5"><col></colgroup><tbody>
</tbody>
<colgroup><col><col><col><col span="5"><col span="2"></colgroup><tbody> </tbody> |
<tbody>
</tbody>
<colgroup><col><col><col><col><col><col span="5"><col span="5"></colgroup><tbody> </tbody> | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
<tbody>
</tbody>