ExcelFlux

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

RowAB
6EntryNet hours
7Monday8
8Tuesday7.5
9Wednesday—
10Adjustment-1
11NotePending
All records
=SUM(B7:B11)

Expected result14.5

See the inputs and instructions for all 3 examples

Syntax

SUM(range)

Copyable formulas

English Excel · en-US
=SUM(B2:B6)
Turkish Excel · tr-TR
=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.

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
Microsoft Excel reference