Sumif using indirect function

[ardykav]

I have a series of tabs, all of which are named by week end date. I also have a totals tab. What I want to do is have the totals tab autosum all of the other tabs even when new tabs are added.

All tabs are formatted the same, Is the best function to use here Sumif with indirect and if so how do i write this formula?

For the below I would like the formula to represent everything under the car type on the other tabs. Tabs are named 02.06.17, 25.05.17, 18.05.17 for example. and the Sales column is column C on all of these.



[TABLE="width: 500"]
<tbody>[TR]
[TD]Type[/TD]
[TD]Sales[/TD]
[/TR]
[TR]
[TD]Mazda[/TD]
[TD]=formula[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[FDibbins]

Best way to do this is to create a list of sheet names and give a range name (I used Tabs). Then use this formula...
=SUMPRODUCT(SUMIF(INDIRECT("'"&Tabs&"'!T6:T1000"),C1,INDIRECT("'"&Tabs&"'!M6:M1000")))

 

[ardykav]

Best way to do this is to create a list of sheet names and give a range name (I used Tabs). Then use this formula...
=SUMPRODUCT(SUMIF(INDIRECT("'"&Tabs&"'!T6:T1000"),C1,INDIRECT("'"&Tabs&"'!M6:M1000")))

That is exactly what I need, thanks so much for that, Life saver!

 

[FDibbins]

Happy to help