SUMIF/SUMIFS Indirect

[smccarthy95]

Hello,

I've attached (I think) an example of what my work looks like. Each tab represents a different location, each color a different team. I'm trying to use the sumif(indirect) formulas to find the totals on the overview tab. Teams review/change qty often and the number of sn may increase/decrease.

Thank you for your assistance in this, have a great day.

 

[smccarthy95]

I've attempted to attached an example but it didn't work.

 

[Aladin Akyurek]

Have a look at this link
https://www.mrexcel.com/forum/excel-questions/119020-sumif-multiple-sheets.html
to see whether it offers what you need.