Start here:
From XL Help ("INDEX"):
If you set row_num or column_num to 0 (zero),
INDEX returns the reference for the entire column
or row, respectively
In article <O3vVTL3aJHA.1528[ at ]TK2MSFTNGP03.phx.gbl>,
"Paul B" <ToMuchSpam[ at ]nospam.com> wrote:
[Quoted Text] > How does this sum sheet1 A1 to the last thing in column A without putting a
> number or foumula in D1? =SUM(Sheet1!A1:INDEX(Sheet1!A:A,$D$1))
>
>
>
> I have use this in D1, =MATCH(9.99999999999999E+307,Sheet1!A:A)
>
> , before to use this kind of formula but today I put the formula in without
> anything in D1 and it looks like it works????
>
>
>
> Is this the best way to do this??
>
>
>
> Thanks, using excel 2003
|