Absolute question when autofilling
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
|