Question

What is meant by SUM (A1: A5)?​

Answer 1

Answer:

For example you can use the function SUM(range) to add and get the sum of all the individual values of a range of cells. Let's say you want to add all the values of cell A1 until cell A5. To manually write A1+A2+A3+A4+A5 is a lot of work, so instead you can use the SUM() function.

Answer 2

It means the sum of all the values in the cells from A1 till A5 in MS Excel