SUM Formula – how to use it in Excel? Take a look here!

SUM Formula – a very useful formula in Excel

SUM formula: Excel iconThis weeks blog is all about that most favourite of functions in Excel the SUM formula! This formula is often seen as one of the favourite functions in Excel as a lot of people need to add up a list of figures for whatever reason and the SUM formula makes it a lot easier! This formula is covered on our Basic Excel training course.


SUM Formula

Generally the formula takes the following format: =SUM(range of cells)

An example of this would be =SUM(b2:b10). This example would add up the contents of 9 cells (cells b2 to b10).

Another example would be =SUM(b2:b10,b14,b20:b25). Here we are mixing the : and , symbols within the brackets.

: this symbol is for a range of figures

, this figure is for discrete figures


SUMIF Formula

Another example can be seen in the SUMIF formula, an example being =SUMIF(b2:b10,”>20″). Here we have added some criteria to the adding operation of SUM so that it only adds those cells in the range b2 to b20 together if the cell contains a number greater than 20.


SUM and INDIRECT Formulas

Our final example is using SUM and INDIRECT together.


Here we fix effectively cell b1 so that if we insert a row above b1 is is still contained within the SUM range. (this is not the case with normal SUM)

This is a more advanced feature and the use of INDIRECT in other ways is contained on our Excel Master class course.


Above we have covered a number of uses for SUM and some examples for it. The basic version of SUM is covered in our Basic Excel course and is often the most popular version of SUM that is used day to day. The other versions are found from our Intermediate up to our Master Class levels of Excel courses.

To find out more about the courses, you take a look at the agendas for our Excel courses on our website here.

Any queries? Please feel free to email us on


We hope you liked this hint and tip, why not take a look at our previous one on key points for using Access?