Thread: "Absolute" questions when autofilling-dragging down the column not
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Danielle
 
Posts: n/a
Default "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.

Reply With QuoteReply With Quote