Excel Formulas for Addition

The next slide shows addition of 6 numbers 5, 10, 15, 20, 30 and 40. The entries were made in row 34. The values were entered as follows:

Cell A34: 5

Cell B34: 10

Cell C34: 15

Cell D34: 20

Cell E34: 30

Cell F34: 40

The formula was written in cell G34. The formula was:

=5+10+15+20+30+40

The answer was 120.

You can use an Excel function SUM along with the cell range A34:F34 to calculate the sum of the above numbers. The formula in such a case will be:

=SUM(A34:F34)

You enter “=” followed by SUM, followed by “(“. Click on the cell with value 5(reference: A34). Drag the mouse to cell with value 40(reference: F34) and drop the mouse. Enter “)” and then press the Enter key.

In the above two examples you learnt how formulas for addition are written in Excel.

Previous

TOC

Next