Apparently you can't do 3-D array formulas in Excel.
Just for discussion, another section of the help mentions the following.
I know it's not really the same thing thou...
Create a 3-D reference to the same cell range on multiple worksheets
Learn about a 3-D refererence:
You can use a 3-D reference to add up budget allocations ...etc
=SUM(Sales:Marketing!B3)
= = = = = = =
:)
Dana DeLouis
On 5/7/2010 4:48 PM, Rich Locus wrote:
Bernard:
Apparently you can't do 3-D array formulas in Excel. See this link:
http://office.microsoft.com/en-us/ex...872901033.aspx
Here's a quote from the page:
A quick introduction to arrays and array formulas
If you've done even a little programming, you've probably run across the
term array. For our purposes, an array is just a collection of items. In
Excel, those items can reside in a single row (called a one-dimensional
horizontal array), a column (a one-dimensional vertical array), or multiple
rows and columns (a two-dimensional array). You can't create
three-dimensional arrays or array formulas in Excel.
--
= = = = = = =
HTH :)
Dana DeLouis