Notifications
Clear all
General Excel Questions & Answers
2
Posts
2
Users
0
Reactions
46
Views
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
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