close

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.=AVERAGE(INDIRECT(quot;sheet1!quot; amp; CHAR(ROW(K1) COLUMN() 64 - 1)amp; 4 amp; quot;:quot; amp;
CHAR(ROW(K1) COLUMN() 64 - 1) amp; 34))
--
Kevin Vaughnquot;Daniellequot; wrote:

gt; I have a formula:
gt; =AVERAGE(Sheet1!K$4:K$34)
gt;
gt; I am trying to drag down on the worksheet (no across)... so the formula will
gt; be:
gt;
gt; =average(sheet1!L$4:L$34)
gt; =average(sheet!M$4:M$34)
gt; and so on...when I drag the formula down the column.
gt;

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()

    E-mail轉寄