View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
PCLIVE PCLIVE is offline
external usenet poster
 
Posts: 1,311
Default What does this mean - =Sum-($C$22:E22)

It maintains the column and row references in the case where the cell is
copied and pasted in another column or row.
Example. If this formula was in A1 and you copied it to B2, the formula
would automatically change to:

=Sum-($C$22:F23)

Notice that cell C22 did not change, but E22 changed to F23.

HTH,
Paul



--

"applesarah" wrote in message
...
What does the $ in front of a letter or number mean ?