A 3-D reference utilizes the same cell, or range of cells, from multiple worksheets in a formula. 3-D references will work with a number of functions in Excel including: SUM, COUNT, and AVERAGE. Let’s look at an example.
Archive for the ‘Microsoft Excel 2007’ Category
Summarize data using 3-D references
Posted in Microsoft Excel 2007 on June 8, 2010 | Leave a Comment »
