All above mentioned formulas are using the relative references which means that these are dynamic ranges, so if you copy these formulas or paste it somewhere else or drag in rows or columns, ranges will be automatically updated relatively.

So when your Excel Ranges are fixed, you should make excel ranges Fixed/Absolute range. In order to make excel ranges absolute, you can fix those excel range by putting “$” i.e. if you want to fix the columns only, you should use

=Sum($A2:$A10) >> Here we are fixing the column "A" or

=Sum(A$2:A$10) >> Here we are fixing the Rows by putting $ front of 2 and 10

=Sum($A$2:$A$10) >> Here we are fixing both Rows and Columns by putting $

## Leave a Reply