sumifs across multiple sheets and variable category

[fish_roi]

Hi,

I was trying to build a table that have a unique account number in the left and according to this number
its looking for this number in a tab that was chosen from a drop down menu in the top
so for example if in cell G3 I picked Act18 , it will sumifs things in tab called Act18, if I picked Bud18 it will sumifs data from the Bud18 and so on, I don't want to use INDIRECT since I have more than 2000 accounts to sumifs so it make
the all story very slow

any ideas?

 

[NonStopLeo]

Hi,

I was trying to build a table that have a unique account number in the left and according to this number
its looking for this number in a tab that was chosen from a drop down menu in the top
so for example if in cell G3 I picked Act18 , it will sumifs things in tab called Act18, if I picked Bud18 it will sumifs data from the Bud18 and so on, I don't want to use INDIRECT since I have more than 2000 accounts to sumifs so it make
the all story very slow

any ideas?

check the formula in the sheet i uploaded in below link if it is ok for ur desired results?

https://jumpshare.com/v/Nan9JeRveLf6eg4DFUNw

 

[fish_roi]

Hi,

thanks for you response
I also did with the if , but if I have a lot of sheets is start to be complicated, and also if I change sheet name, I need to change all formulas,
and when I have 2000 lines it also heavy,
I need to think for something more efficient and quick

thanks

 

[Dryver14]

If I change the sheet Name??? why on earth would you be thinking about that?

 

[fish_roi]

If you want to have new tab Budget 2019 for example..
this is why you change the names