ExcelBanter - "Absolute" questions when autofilling-dragging down the column not

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - "Absolute" questions when autofilling-dragging down the column not (https://www.excelbanter.com/excel-worksheet-functions/71860-absolute-questions-when-autofilling-dragging-down-column-not.html)

Danielle

"Absolute" questions when autofilling-dragging down the column not

I have a formula:
=AVERAGE(Sheet1!K$4:K$34)

I am trying to drag down on the worksheet (no across)... so the formula will
be:

=average(sheet1!L$4:L$34)
=average(sheet!M$4:M$34)
and so on...when I drag the formula down the column.

Kevin Vaughn

"Absolute" questions when autofilling-dragging down the column not

=AVERAGE(INDIRECT("sheet1!" & CHAR(ROW(K1)+COLUMN()+64 - 1)& 4 & ":" &
CHAR(ROW(K1) + COLUMN() + 64 - 1) & 34))
--
Kevin Vaughn

"Danielle" wrote:

I have a formula:
=AVERAGE(Sheet1!K$4:K$34)

I am trying to drag down on the worksheet (no across)... so the formula will
be:

=average(sheet1!L$4:L$34)
=average(sheet!M$4:M$34)
and so on...when I drag the formula down the column.

All times are GMT +1. The time now is 06:56 PM.