Hello!
Running into an issue when trying to create a 3D Sumproduct formula, which I have come to find out is not possible in MS Excel 2010 since the Morefunc add-in is not compatible, to use THREED function.
Trying to figure out the work around using a "SUMPRODUCT(N(INDIRECT" function, but having issues lining it up with my data.
The formula I have now is:
Some notes to help:
-"First" is the first tab in workbook "Divide" is the last
-Master!B2 is a project which will be located in E3-Z3 on the First-Divide sheets(this list goes down through Master!B10000, all of which can be manually input in E3-Z3)
-Sum Range is E5-Z110 on First-Divide tabs
Any advice on how this would translate to the "sumproduct(n(indirect" formula string would be EXTREMELY helpful!
Thank you!
Running into an issue when trying to create a 3D Sumproduct formula, which I have come to find out is not possible in MS Excel 2010 since the Morefunc add-in is not compatible, to use THREED function.
Trying to figure out the work around using a "SUMPRODUCT(N(INDIRECT" function, but having issues lining it up with my data.
The formula I have now is:
Code:
=IF(ISBLANK($B2),"0",SUMPRODUCT(('First:Divide'!$E$3:$Z$3=Master!$B2)*('First:Divide'!$B$5:$B$110="AccountL")),First:Divide!$E$5:$Z$110))Some notes to help:
-"First" is the first tab in workbook "Divide" is the last
-Master!B2 is a project which will be located in E3-Z3 on the First-Divide sheets(this list goes down through Master!B10000, all of which can be manually input in E3-Z3)
-Sum Range is E5-Z110 on First-Divide tabs
Any advice on how this would translate to the "sumproduct(n(indirect" formula string would be EXTREMELY helpful!
Thank you!
