Using dynamic range in functions

  • Thread starter Thread starter rrk
  • Start date Start date
R

rrk

Hi all,

I have a set of data in one column from row 1 to 100. How can I
calculate the average of the data from row 1 to row i? The value of i
is located in another cell. Thanks in advance.
 
Debra Dalgleish said:
With the variable in cell D1:

=AVERAGE(INDIRECT("A1:A"&D1))
Click to expand...

Thanks a lot. Using this function made my life much easier.

rrk
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
hLookup dynamic range 2
Excel VBA 1
Excel Help to copy information from one row at a time to another sheet 1
Using the contents of a ADDRESS formula as the cell range in a for 3
Help on lookup functions 4
Average value only for the filtered area.. 4
Dynamic display 1

Back
Top