$ in cell reference?

  • Thread starter Thread starter Fredrated
  • Start date Start date
F

Fredrated

Pardon me if this is a stupid question, I am an access programmer
manipulating an excel spreadsheet with the object model.

What is the function of the $ in the following cell entry?:
=AVERAGE(S$3:S$33)

Thanks for any help.

Fred
 
It's so when you copy or move your formula to other cells, the 3 and 33 won't
change. The S colum will.
So say this formula was in A1. If you copied it to B1, it would read:
=AVERAGE(T$3:T$33)

Likewise, if the $ were in front of the S, then the S's wouldn't change
either when you copy the formula.
 
It means that the cell range is fixed; it does not move if you copy it
elsewhere in the Worksheet.

Please hit yes if my comments have helped.
 
Hi
This is from the help file in XL
$A$1 (absolute (absolute cell reference: In a formula, the exact address of a
cell, regardless of the position of the cell that contains the formula. An
absolute cell reference takes the form $A$1.) column and absolute row) $A$1
A$1 (relative (relative reference: In a formula, the address of a cell based on
the relative position of the cell that contains the formula and the cell
referred to. If you copy the formula, the reference automatically adjusts. A
relative reference takes the form A1.) column and absolute row) C$1
$A1 (absolute column and relative row) $A3
A1 (relative column and relative row) C3

HTH
John
 
Hi,

The $ means "static value." This is often use in formulas to make cells,
rows or columns stay static when duplicating them in different areas of the
spreadsheet. For instance if you grab cell A$3 and turn it into A3 and
duplicate the formula to the right the formula will look something like this:
B$3.

Hope this helps!

Vicente
 
Back
Top