Creating a Summary worksheet (Cube) directly in Excel.
As you move to PerformancePoint for reporting, this scenario will hopefully be less relevant.
But what if you have 25 worksheets and you need to sum up the same fields in all of them on a consolidation worksheet.
Named ranges and colons are your friend.
What is a 3D Formula ?
These are also known as cubed formulas.
A reference that refers to the same cell or range on multiple worksheets is called a 3D reference.
Using 3D formulas allows you to calculate data thorughout a workbook using multiple worksheets.
All 3D formulas are based on the syntax: Sheet1:Sheet4!A2:B5.
A 3D formula is a formula that refers to the same cell (or range of cells) on multiple worksheets.
The 3D formula "=SUM(Sheet1:Sheet4!A2)" can be used to add up the numbers in cell "A2" on 4 different worksheets.
No comments:
Post a Comment