Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old June 29th 06, 06:56 PM
Junior Member
 
First recorded activity by ExcelBanter: Jun 2006
Posts: 1
Default Using the "$" as part of a cell reference

Could someone please explain in more detail the usage of above. I have seen this usage in:

=AVERAGE($6:$6) to yield a dynamic average across row 6. This does not seem to work in a Column setup. I am looking for more details, links, etc.

Thank You.
Alan

  #2   Report Post  
Old June 29th 06, 07:54 PM posted to microsoft.public.excel.worksheet.functions
Marcelo
 
Posts: n/a
Default Using the "$" as part of a cell reference

Hi the use of $ is to change a formula absolute to relatvie, you could use it
in a Column as =AVERAGE($A:$A) or in specific range or unique cell

hth
regards from Brazil
Marcelo

"awy32" escreveu:


Could someone please explain in more detail the usage of above. I have
seen this usage in:

=AVERAGE($6:$6) to yield a dynamic average across row 6. This does not
seem to work in a Column setup. I am looking for more details, links,
etc.

Thank You.
Alan


--
awy32

  #3   Report Post  
Old June 29th 06, 08:28 PM posted to microsoft.public.excel.worksheet.functions
Gord Dibben
 
Posts: n/a
Default Using the "$" as part of a cell reference

Recent posting by Kassie...........

The $ sign is used to make a cell address an
absolute one.

If you copy any formula that refers to a cell address, say =SUM(A1:A10) to
the next row, Excel changes the formula to read =SUM(A2:A11).
If however, you copy a formula reading =SUM($A1:A10) , Excel changes the
formula to
Copy down =SUM($A2:A11).
Copy right =SUM($A1:B10)
If you enter the formula as =SUM($A$1:A10), it will change to
Copy down =SUM($A$1:A11),
Copy right =SUM($A$1:B10)
The formula =SUM(A$1:A10, will change to
Copy down=SUM(A$1:A11),
Copy right =SUM(B$1:B10)
If you enter it as =SUM($A$1:$A$10), and you copy it to any other location
on your spreadsheet, it will still read =SUM($A$1:$A$10)
In other words, the $ sign in front of a column reference loks subsequent
copies to that column. The $ in front of a row reference, locks subsequent
copies to that row. You can also insert the $ before the latter parts of the
formula, to lock either the column or row reference, eg =SUM(A1:$A10), which
can change as follows: Copy down =SUM(A2:$A11)
Copy right =SUM(B1:$A10)

=SUM(A1:A$10) will change to
Copy Down =SUM(A2:A$10)
Copy right =SUM(B1:B$10)


Gord Dibben MS Excel MVP

On Thu, 29 Jun 2006 18:56:08 +0100, awy32
wrote:


Could someone please explain in more detail the usage of above. I have
seen this usage in:

=AVERAGE($6:$6) to yield a dynamic average across row 6. This does not
seem to work in a Column setup. I am looking for more details, links,
etc.

Thank You.
Alan


  #4   Report Post  
Old June 30th 06, 12:43 AM posted to microsoft.public.excel.worksheet.functions
L. Howard Kittle
 
Posts: n/a
Default Using the "$" as part of a cell reference

Along with Gord's explanation you might want to see what the F4 key will do.
Type =A1, then before hitting Enter, hit the F4 key four times and notice
the reference changes.

HTH
Regards,
Howard


"awy32" wrote in message
...

Could someone please explain in more detail the usage of above. I have
seen this usage in:

=AVERAGE($6:$6) to yield a dynamic average across row 6. This does not
seem to work in a Column setup. I am looking for more details, links,
etc.

Thank You.
Alan


--
awy32





Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Help with this conditional IF statement C-Dawg Excel Discussion (Misc queries) 3 May 15th 06 06:01 PM
Using a cell reference as part of a link Missy Excel Discussion (Misc queries) 3 February 3rd 06 08:48 PM
Bring the cell format along with the cell value from a reference c Lorrie Horgen Excel Worksheet Functions 1 January 20th 06 09:52 PM
Input cell reference is not valid (One Variable Data Table) Dottore Excel Worksheet Functions 9 September 1st 05 03:05 PM
worksheet tab name as part of a cell reference cwee Excel Worksheet Functions 4 February 10th 05 04:37 PM


All times are GMT +1. The time now is 05:08 AM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017