I have a workbook with four sheets. The first sheet is called "Summary" and the other 3 are called (0,1, and 2). The sheets named with a number basically represents the month.
My summary sheet will contain a formula that the user will choose the month or range of months to sum across the number tabs based on two other criteria like account and Unit number display in the summary tabs
A1=Month or a range of Months like 1 or range from 0-2
I have tried using indirect with sumifs to no avail.
I think I need a sumproduct,sumifs,indirect
combination with range names for the months in D8 of my summary tab.
I'm attaching my file to make it more clear for you.