Prev: Any help with inserting, copying and transferring data.
Next: Excel formula needed to round up a value to a whole number
From: Rich Locus on 8 May 2010 14:38
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/excel/HA010872901033.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
> .
>
First  |  Prev  | 
Pages: 1 2
Prev: Any help with inserting, copying and transferring data.
Next: Excel formula needed to round up a value to a whole number