Forum

Notifications
Clear all

Custom Toggles for 3D SUMIF Across Multiple Worksheets

2 Posts
2 Users
0 Reactions
46 Views
 J C
(@excelcheck)
Posts: 1
New Member
Topic starter
 
Regarding 3D SUMIF Across Multiple Worksheets, is it possible to have a cell that allows you to change the range of tabs to reference / sum?
 
In the original workbook, the indirect function refers to 'tabs' which is the named range. I wanted to see if it were possible to have the sumproduct function refer to a cell which names the appropriate range to reference. 
 
I attached a screenshot I'd like to be doing (cell B5 trying to reference cell B12 as opposed to explicitly typing out the named cell range). It obviously doesn't work, but I wanted to ask if this were even possible. 
 
 
Posted : 27/06/2018 5:45 pm
Anders Sehlstedt
(@sehlsan)
Posts: 968
Prominent Member
 

Hi,

Check this blog. It should work as you want it.

https://www.myonlinetraininghub.com/excel-3d-sumif-across-multiple-worksheets

/Anders

 
Posted : 28/06/2018 1:26 am
Share: