Dynamic MultiColumn SumIF Formula

All,

I'm having trouble with the following (see attached for example problem). I'd like to write a "sumifs-like" formula that can accommodate a multi-column sumrange based upon today's date and month.

For example, if sumifs criteria are met, the formula would sum column 1 through column x (column x's header would be today's month and fiscal year).

Any ideas? The example workbook should provide a more clear description of the problem.

Thanks in advance!

It's almost always easier and simpler to use actual dates rather than text dates.

With that thought in mind in E14 enter 10/1/2018 for the start date. In F14 and across

Formula:

=EDATE(E14,1)

Use those for column referencing.

There is no APE # in D6. This formula does not explicitly include the APE #s. Add another criteria to this formula if that changes.

Formula:

=SUMPRODUCT((A6=$A$16:$A$20)*(B6=$B$16:$B$20)*(C6=$C$16:$C$20)*INDEX($E$16:$L$20,,1):INDEX($E$16:$L$20,,MATCH(EOMONTH(--RIGHT(E$5,6),-1)+1,$E$14:$L$14,1)))

Try changing the date in E14 to 10/1/2018

You are welcome. Glad to help. Thank you for the feedback and marking your thread Solved.