You can use cell references without row numbers.

For instance, the formula `=sum(C:C)`

will add up all the values in column C of the active sheet. This is helpful when you are adding and removing rows but don’t want to update your formulas each time.

There are some instances when using this whole column reference is not a good idea. There is a good article here. It discusses many different variables and test cases to explain when it would be beneficial to use something like `=sum(C:C)`

or to use something like `=sum(C1:C1000)`

.

A | B | C | D | E |
---|---|---|---|---|

1 | Bob | 4 | the formula: =sum(C:C) = | 20 |

2 | Pete | 7 | ||

3 | Mary | 9 |

if you want to reproduce, please indicate the source:

Getting started with excel-formula – Excel cell references - CodeDay