Absolute question when autofilling

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.

Try dragging across to get as many as you need.

Then select them
edit|copy
select where you really want the formulas to be
edit|paste special|check transpose.

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.

--

Dave Peterson

Brilliant! Thanks - didn't even think about that.

"Dave Peterson" wrote:

> Try dragging across to get as many as you need.
>
> Then select them
> edit|copy
> select where you really want the formulas to be
> edit|paste special|check transpose.
>
> 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.
>
> --
>
> Dave Peterson
>