All lessons
Excel Basicsbeginner
The SUM Function
Learn to add up numbers with the SUM function, the most-used formula in Excel.
0 of 3 exercises complete
Add two cells
In cell B5, write a formula that adds cell B2 and cell B3 together. Use =B2+B3 or =SUM(B2:B3).
Sum a range
In cell B7, use SUM to add up all the amounts from B2 to B6 in one formula.
Sum non-adjacent cells
In cell D2, add together only the Food amounts: B2 and B4 (skip the drinks in B3 and B5). Use =SUM(B2,B4).