Dana;

I saw that information on 3D sums also. When reading further, I think they
mean something different. I believe they are talking about references across
multiple worksheets and not 3-D arrays.

Yes, the English language can be ambiguous if the author is not careful.
--
Rich Locus
Logicwurks, LLC


"Dana DeLouis" wrote:

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
.