SUM FUNCTION

Occasional Visitor

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?

1 Reply

@NANNANCY 

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.

 

Hope I was able to help you with this info.

 

NikolinoDE

I know I don't know anything (Socrates)