| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
$ in cell reference?
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 "Fredrated" wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Changing sheet reference to cell reference | Excel Worksheet Functions | |||
| Formulas that reference cells that reference another cell | Excel Discussion (Misc queries) | |||
| absolute cell reference A spreadsheet cell reference that does no | Excel Discussion (Misc queries) | |||
| problem with cell reference in =sum(offset(cell reference,x,y,z,a)). Want cell ref to be variable. | Excel Worksheet Functions | |||
| Problem with =sum(offset(cell reference,w,x,y,z). I want cell reference to be variable | Excel Worksheet Functions | |||
Hybrid Mode
