Assuming we intend to sum the values in Column C while keeping the “value” in Column D as D4 in the formula, we will add the dollar sign before copying down the formula as shown in Figure 4. If we copy down the formula in Cell C9, the cell reference changes to sum Cell C5 and Cell D5įigure 3 – How to keep a value constant How to Keep Cell Value Constant with the F4 key
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |