# SUM FUNCTION

Occasional Visitor

# SUM FUNCTION

I USE THE SUM FUNCTION TO SUM NUMBERS IN A COLUMN ABOVE.

I SUM MANY COLUMNS IN DIFFERENT AREAS OF THE WORKSHEET.

I WANT TO SUM ALL SUMS TOGETHER.

E1 TO E5 SUMMED IN E6

E10 TO E20 SUMMED IN E21

HOW CAN I SUM E6 AND E21 TOGETHER?

# Re: SUM FUNCTION

Use the SUM function to sum numbers in a range

You can use a simple formula to sum numbers in a range (a group of cells), but the SUM function is easier to use when you’re working with more than a few numbers.

=SUM(E1:E5) put formula in E6

=SUM(E10:E20) put formula in E21

=SUM(E6;E21)  put formula in Cell you wish.