Sumifs multiple worksheet

[ikimashu]

Hello,

I am looking to sum the total of sales by date condition.
Each different month has its own worksheet, wonder how to cross sheet sum based on the date ranges I want.

I have tried the sumproduct and indirect as found on most internet search results.
However my monthly data ranges are not consistent, they are all in a table range.
Wonder if I can use table range as dynamic range.

Please find attached my sample file.

Ps. The file has a little vba coding to ease my date changes.

Thank you.

[Glenn Kennedy]

You have attached a 1Mb file. I have not downloaded it. Forum guidelines suggest 10-20 rows. 1 Mb suggests you have THOUSANDS, maybe 10s of thousands of rows.

Please read the yellow banner (top) and upload a sample file that meets our guidelines.