How do you add up multiple cells in Excel?

Answer 1

There's a couple of options:

1. Highlight the cells you want to add and you'll get a total in the bottom right. This is the quickest way to add up numbers but the total is not stored on the spreadsheet

2. Use the SUM formula. Say you want to add up cells A1, A2, A3 and A4. The formula looks like this: =SUM(A1:A4)

3. You can simply add them. Say you want to add A1, A3, B6. The formula looks like this:

=A1+A3+B6

I hope this answers your question.