ExcelFunctions.net

Search Site:

A | B | |
---|---|---|

1 | = 2 + 7 + 1 | |

2 | ||

3 |

The most simple Excel addition formula consists of the = sign, followed by a list of two or more numbers with the + operator in between them. This is shown in the spreadsheet on the right above spreadsheet.

The excel addition formula in the example spreadsheet calculates the sum of the three numbers
2, 7 and 1 and returns the result *10*.

A | B | |
---|---|---|

1 | = B1 + B2 + B3 | 2 |

2 | 7 | |

3 | 1 |

As with all Excel formulas, instead of typing in the numbers directly, you can use references to cells containing numbers.

The Excel addition formula in cell A1 of the spreadsheet on the right
above spreadsheet adds together the contents of
cells B1, B2 and B3. Again, the formula returns the value *10*.

Instead of using the + operator Excel provides a built-in Sum Function that can be used to perform addition in Excel. This function is called by entering the following into an Excel cell:

=SUM( number1, [number2], ... )

A | B | |
---|---|---|

1 | =SUM( B1, B2, B3 ) | 2 |

2 | 7 | |

3 | 1 |

where number1, [number2], etc. are one or more numbers (or references to cells containing numbers) that you want to add together.

The Sum function is used in cell A1 of the spreadsheet on the right
above spreadsheet. In this example, the function
is used to add together the three values in cells B1, B2 and B3, and therefore, returns the
value *10*.

For more information and examples of the Sum function, see the Excel Sum Function page.