Absolute question when autofilling

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 

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

"Absolute" questions when autofilling-dragging down the column not 1
Sum Total 2
Nested if formula question 3
Removing #N/A 4
Scrabble Value calculation for Welsh words 0
Average Calculation for Sunday School Year Long Goal 1
Excel A CountIF question... I think 2
automatically average the last 4 columns 10

Back
Top