SUM function
SUM adds numbers, cell references, and ranges.
Math and trigonometry
Where can you use it?
Reporting, manufacturing and engineering teams. When a total, rounding step or numerical transformation is needed, use the example to see which operation fits your inputs.
Scenario in the workbook
Total shift hours. Empty shifts and text notes are ignored in a range; negative adjustments reduce the total.
A worked example from the workbook
| Row | A | B |
|---|---|---|
| 6 | Entry | Net hours |
| 7 | Monday | 8 |
| 8 | Tuesday | 7.5 |
| 9 | Wednesday | — |
| 10 | Adjustment | -1 |
| 11 | Note | Pending |
=SUM(B7:B11)Expected result14.5
See the inputs and instructions for all 3 examplesSyntax
SUM(range)
Copyable formulas
=SUM(B2:B6)=TOPLA(B2:B6)Sample data
Enter the headers and sample records in A1:B6.
| Entry | Net hours |
|---|---|
| Monday | 8 |
| Tuesday | 7.5 |
| Wednesday | |
| Adjustment | -1 |
| Note | Pending |
Enter hours as decimal numbers.
Enter the formula in D2.
To try the Turkish formula, use the sample data on the Turkish page.
Expected result
14.5
How it works
Blank cells and text in a referenced range are ignored. A negative adjustment reduces the total. Convert imported hours stored as text to numbers. With Excel time values, use an elapsed-time format for totals that can exceed 24 hours.
Syntax
SUM(number1, [number2], …)
Compatibility
Excel for Microsoft 365 and Excel 2016, 2019, 2021, and 2024.
Related pages
Worked examples
Total shift hours. Empty shifts and text notes are ignored in a range; negative adjustments reduce the total.
Open the English sheet. Inputs begin at A6. F7:F9 show the live results and G7:G9 show the original results for comparison.
| Row | A | B |
|---|---|---|
| 6 | Entry | Net hours |
| 7 | Monday | 8 |
| 8 | Tuesday | 7.5 |
| 9 | Wednesday | — |
| 10 | Adjustment | -1 |
| 11 | Note | Pending |
| Case | Formula | Expected result |
|---|---|---|
| All records | =SUM(B7:B11) |
14.5 |
| Before adjustment | =SUM(B7:B9) |
15.5 |
| Text note only | =SUM(B11) |
0 |