Number of Observations
 

I have a column (say Column A) with 300 values (basically it is a DDE link
with data I update).

I also have a cell I would like to use (say B1). In cell B1 I would like to
be able to enter a value (say 20) where I will be able to use this value in
another cell to "observe" the top 20 of the cell from column A. So, If I put
20 in cell B1, in cell (say C1) I would like to put some formula where it can
reference the "how many observation" cell B1, and say sum A1:AXX where xx is
the value in cell B1.

I know in this form it cannot be done, but was wondering if someone had an
idea how to get this concept to work,

Thank you for your time.
Diane

Hi
do you mean
=SUM(INDIRECT("A1:A" & B1))

--
Regards
Frank Kabel
Frankfurt, Germany
"Diane" schrieb im Newsbeitrag
...
I have a column (say Column A) with 300 values (basically it is a DDE link
with data I update).

I also have a cell I would like to use (say B1). In cell B1 I would like
to
be able to enter a value (say 20) where I will be able to use this value
in
another cell to "observe" the top 20 of the cell from column A. So, If I
put
20 in cell B1, in cell (say C1) I would like to put some formula where it
can
reference the "how many observation" cell B1, and say sum A1:AXX where xx
is
the value in cell B1.

I know in this form it cannot be done, but was wondering if someone had an
idea how to get this concept to work,

Thank you for your time.
Diane

Diane,

In cell C1:

=SUM(INDIRECT("A1:A"&B1))

HTH,
Bernie
MS Excel MVP

"Diane" wrote in message
...
I have a column (say Column A) with 300 values (basically it is a DDE link
with data I update).

I also have a cell I would like to use (say B1). In cell B1 I would like
to
be able to enter a value (say 20) where I will be able to use this value
in
another cell to "observe" the top 20 of the cell from column A. So, If I
put
20 in cell B1, in cell (say C1) I would like to put some formula where it
can
reference the "how many observation" cell B1, and say sum A1:AXX where xx
is
the value in cell B1.

I know in this form it cannot be done, but was wondering if someone had an
idea how to get this concept to work,

Thank you for your time.
Diane

=SUM(A1:INDEX(A:A,B1))

On Tue, 21 Dec 2004 10:17:05 -0800, "Diane"
wrote:

I have a column (say Column A) with 300 values (basically it is a DDE link
with data I update).

I also have a cell I would like to use (say B1). In cell B1 I would like to
be able to enter a value (say 20) where I will be able to use this value in
another cell to "observe" the top 20 of the cell from column A. So, If I put
20 in cell B1, in cell (say C1) I would like to put some formula where it can
reference the "how many observation" cell B1, and say sum A1:AXX where xx is
the value in cell B1.

I know in this form it cannot be done, but was wondering if someone had an
idea how to get this concept to work,

Thank you for your time.
Diane