Sum multiple sheets with criteria

[bandit6611]

I am trying to add up a certain cell in multiple sheets if 2 other cells match a certain number. Example:

the sheets are month-day:
1-2
1-3
thru
8-26
All of the sheets are formatted the same way.

I want to add cell b4 in each sheet if d4=3 and e4=22.5 in each sheet so I tried this:

=sumifs('1-2:8-26'!B4,'1-2:8-26'!D4,"=3",'1-2:8-26'!E4,"=22.5")
but I get a #VALUE! - what am I doing wrong?

[FDibbins]

Hi, welcome to the forum

1. sumifs() does not work across sheets.
2. you dont need to use ,"=3", you can just use ,3,
3. You would use a variation in this for what you want...
=SUMPRODUCT(SUMIF(INDIRECT("'"&Tabs&"'!T6:T1000"),C794,INDIRECT("'"&Tabs&"'!M6:M1000")))
You need to create a list of sheet names, and then give that list a range name (I used Tabs)
4. if you still have a problem, upload a small (clean) sample workbook (not a pic) of what you are working with, and what your expected outcome would look like.

[bandit6611]

Thank you Ford for the response, I got lost at the range name and how to use that. I attached a sample workbook - In the summary sheet, I want to add b4 thru 8-24 to 8-26 if d4 in that sheet =3 and e4 in that sheet =22.5. So even more simply, if in sheet 8-24 d4=3 and e4=22.5 then it would add that value, then the same for 8-25 and 8-26.