none
Interpretation of '$A$16:$A$375'? RRS feed

  • Question

  • What does "$A$16:$A$375" mean?

    Do you have any concrete example?

    Maybe you have a tutorial?

    Thanks!

    Friday, April 3, 2015 12:09 PM

All replies

  • $A$16:$A$375 is the range of cells in column A from row 16 up to and including row 375.

    The $ symbols mean that Excel will not adjust this range if you copy the formula to another cell, or if you fill the formula down. This is called an absolute reference.

    A reference such as E16:E375, without the $ symbols, is called a relative reference. If you copy the formula to another cell, Excel will automatically adjust this range.

    See for example http://www.gcflearnfree.org/excel2013/15 or http://web.pdx.edu/~stipakb/CellRefs.htm for more information on absolute and relative cell references.


    Regards, Hans Vogelaar (http://www.eileenslounge.com)

    • Proposed as answer by ryguy72 Friday, April 3, 2015 1:28 PM
    Friday, April 3, 2015 12:38 PM