SumIfs Help or Alternative Formula

[MJLG85]

Hello

I'm trying my best to construct a Formula to read across several sheets that will pick up everytime a in column B the 31 different sheets it says X (which its reading from Sheet1 H3) and the value matches (what Sheet1 I3) then it will add up from all the sheets (name simply 1 and 2 etc)

=sumifs('1'!$E$3:$E$29,'1'!$B$3:$B$29,Sheet1!$H$3,'1'!$D$3:$D$29,Sheet1!$I$3)

This works if i am just checking 1 sheet. But when I change it to read accross the 31 sheet it jus returns a "value" error.

=sumifs('1:31'!$E$3:$E$29,'1:31'!$B$3:$B$29,Sheet1!$H$3,'1:31'!$D$3:$D$29,Sheet1!$I$3)

What am I doing wrong or is there a better formula?

Thanks

 

[DanteAmor]

Sumif does not work for multiple sheets.

Review this
https://exceljet.net/formula/3d-sumif-for-multiple-worksheets