Home » Our Blog » Excel Essential Skills » Functions

Category: Functions

How to total a range of cells in Excel

sharyn bainesThe quickest way to total a range of cells in Excel is to use the SUM function.

The Sum function is one of the most commonly used functions in Excel. The function requires the first and last cells within a list, it then includes them and every cell between them into the total. For example =SUM(C4:C10) replaces the need to enter =C4+C5+C6+C7+C8+C9+C10.

Maybe you could just create a formula to add each of the cells when there only 7 of them…but imagine if there were 7000! Yikes! That’s when the SUM function becomes an amazing tool to have in your toolbox.
Read more