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!