Recently i landed upon a brilliant techniques demonstrated by Better Solutions for illustrating the CUBED FORMULA, power of excel. This techniques thrust's excel to aggreagte same worksheet locations on diffrent sheets mentioned in the formula as workshet series.
"Sheet1:Sheet4!A2:B5". This technique can be used in formula as "=Sum(Sheet1:Sheet4!A2:B5)"
This technique would help aggreagate the certain ranges from each sheet specified adress and contained withing the worksheet series. Though being an advantage one has to be care ful to be aware that movement of order of sheets would alter the logic of formula performed and the intended result.
For further information please check the refrence for more in detail description of the functionality.
Refrences:
Better Solutions : Link
No comments:
Post a Comment