How do I use SUM in Excel?
Use SUM when you want to sum sales or numeric values. Enter Target range, Additional range in that order, then add optional arguments when needed.
Excel Function
SUM
Returns the sum of selected values or ranges.
SUM(number1, [number2], ...)Arguments
number1
RequiredSpecify the first number or range to calculate.
number2
OptionalOptional second argument; leave blank when not needed.
Practice Preview
Use SUM to aggregate Sales in column D. You can set ranges by dragging from the start cell to the end cell in the same argument field.
Example Table
| # | AProduct ID | BProduct Name | CCategory | DSales |
|---|---|---|---|---|
| 2 | P001 | Apple | Food | 1200 |
| 3 | P002 | Banana | Food | 980 |
| 4 | P003 | Notebook | Stationery | 450 |
| 5 | P004 | Pen | Stationery | 300 |
| 6 | P005 | Grapes | Food | 1500 |
| 7 | P006 | Ruler | Stationery | 250 |
| 8 | P007 | Peach | Food | 860 |
How to Use (Formula)
=SUM(D2:D8)Result
5540
Practice This Function
SUM FAQ
Where can I practice SUM?
Use the "Start Function Practice" button to jump straight into SUM drills.
What arguments does SUM use?
The main arguments are Target range, Additional range. Start with the required ones, then add optional arguments if needed.