What does this mean - =Sum-($C$22:E22)
The dollar sign ($) is a flag to Excel to "lock" that
part of the reference when copy/pasting the cell.
Examples:
A1: =B1
Copy A1 and paste in C2.
The formula in C1 is: =D2
A1: =$B1
Copy A1 and paste in C2.
The formula in C1 is: =$B2
A1: =B$1
Copy A1 and paste in C2.
The formula in C1 is: =D$1
A1: =$B$1
Copy A1 and paste in C2.
The formula in C1 is: =$B$1
For more information, search Excel Help for "range references"
and see the "about cell and range references" section
and select the "The difference between relative and absolute references"
topic
Does that help?
--------------------------
Regards,
Ron
Microsoft MVP (Excel)
(XL2003, Win XP)
"applesarah" wrote in message
...
What does the $ in front of a letter or number mean ?
|