SUMIFS across multiple sheets using multiple criteria function not working

Good evening all

I apologise for I have read all of the posts on this very subject but none of the solutions work for me. Attached I have an example spreadsheet where I want the summary sheet (sheet 4 in this example) to sum all of the meals from all of the month sheets for each user. I have named my range for the months (Jan, Feb Mar) and even error wrapped the code, but it just will not work. Before you take a look, the formula I am using is:

=IFERROR(SUMPRODUCT(SUMIFS(INDIRECT("'"&Dates&"'!C8:C31),Sheet4!J2,INDIRECT(Sheet4!&Dates&"'!A8:A31),INDIRECT("'"&Dates&"'!A8:A31),Sheet4!A3))),)

I am trying this formula is cell B3 initially and once correct will amend and place in the cells B3 through to E7.

Please could someone help me over the line as I believe the code isn't too far off.
Many thanks in advance
G1

Hello Daddylonglegs

Thanks for your reply sir. I've left me spreadsheet at home so will check and get back to you later.

Thanks
G1

Good evening daddylonglegs

First of all thank you for your code, it does exactly what I was trying to achieve. If I may ask one more additional question, as you have noticed my workbook only has 3 months on it. A new sheet will be added each month as the year goes by. As such I wanted to change the definition range to incorporate the remaining 9 months, and to 'future proof' the code by error wrapping it as listed below, so the code would still work even if the definition months are not yet created. But this does not work. Is there an easy way to do this or is it a case of just having to amend the definition range after the new month is added?

=IFERROR(SUMPRODUCT(SUMIFS(INDIRECT("'"&Months&"'!C8:C31"),INDIRECT("'"&Months&"'!A8:A31"),$A4,INDIRECT("'"&Months&"'!B8:B31"),B$2)),)

Thanks again Sir

G1

Good evening sir

It's Sat night so don't expect to hear from you until next week.

Just to say thanks again. The code works but now it's only summing from 1 sheet and not all sheets. Would the SUMPRODUCT instruction need to be re-added or maybe it's just a case of me amending the range as I add a new sheet (which isn't too much of a hassle to do).

Many thanks
G1

Daddylonglegs, you are an absolute wizard sir, thank you for helping me out. It worked perfectly.

Thanks again and have a good night

Until the next time

G1