20 examples of how to use the SUM function

 Here are 20 examples of how to use the SUM function in Excel, including formulas and sample data. The SUM function is used to add up numbers in a range of cells.

---

Example 1: Basic SUM

Data:
A1: 5
A2: 10
A3: 15

Formula:
=SUM(A1:A3)
Result: 30

---

Example 2: SUM with Individual Cells

Data:
A1: 2
B1: 3
C1: 5

Formula:
=SUM(A1, B1, C1)
Result: 10

---

Example 3: SUM with Mixed Ranges and Cells

Data:
A1: 10
A2: 20
B1: 30

Formula:
=SUM(A1:A2, B1)
Result: 60

---

Example 4: SUM with Negative Numbers

Data:
A1: 50
A2: -20
A3: 30

Formula:
=SUM(A1:A3)
Result: 60

---

Example 5: SUM with Decimals

Data:
A1: 1.5
A2: 2.3
A3: 4.2

Formula:
=SUM(A1:A3)
Result: 8.0

---

Example 6: SUM Across Multiple Columns

Data:
A1: 10
B1: 20
C1: 30

Formula:
=SUM(A1:C1)
Result: 60

---

Example 7: SUM with Blank Cells

Data:
A1: 5
A2: (blank)
A3: 10

Formula:
=SUM(A1:A3)
Result: 15

---

Example 8: SUM with Text (Ignored)

Data:
A1: 10
A2: "Apple"
A3: 20

Formula:
=SUM(A1:A3)
Result: 30

---

Example 9: SUM with Logical Values (Ignored)

Data:
A1: 10
A2: TRUE
A3: 20

Formula:
=SUM(A1:A3)
Result: 30

---

Example 10: SUM with Multiple Ranges

Data:
A1: 5
A2: 10
B1: 15
B2: 20

Formula:
=SUM(A1:A2, B1:B2)
Result: 50

---

Example 11: SUM with Manual Values

Formula:
=SUM(10, 20, 30)
Result: 60

---

Example 12: SUM with a Single Cell

Data:
A1: 100

Formula:
=SUM(A1)
Result: 100

---

Example 13: SUM with a Large Range

Data:
A1:A100: Numbers from 1 to 100

Formula:
=SUM(A1:A100)
Result: 5050

---

Example 14: SUM with Non-Adjacent Ranges

Data:
A1: 10
B1: 20
C1: 30
D1: 40

Formula:
=SUM(A1, C1)
Result: 40

---

Example 15: SUM with a Formula Inside

Data:
A1: 10
A2: 20

Formula:
=SUM(A1 + A2)
Result: 30

---

Example 16: SUM with a Condition (Using SUMIF)

Data:
A1: 10
A2: 20
A3: 30

Formula:
=SUMIF(A1:A3, ">15")
Result: 50

---

Example 17: SUM with Multiple Conditions (Using SUMIFS)

Data:
A1: 10
A2: 20
A3: 30
B1: "Apple"
B2: "Banana"
B3: "Apple"

Formula:
=SUMIFS(A1:A3, B1:B3, "Apple")
Result: 40

---

Example 18: SUM with Dates (as Serial Numbers)

Data:
A1: 01/01/2023 (Excel stores as 44927)
A2: 01/02/2023 (Excel stores as 44928)

Formula:
=SUM(A1:A2)
Result: 89855

---

Example 19: SUM with Errors (Using IFERROR)

Data:
A1: 10
A2: #DIV/0!
A3: 20

Formula:
=SUM(IFERROR(A1:A3, 0))
Result: 30

---

Example 20: SUM with Dynamic Range (Using OFFSET)

Data:
A1: 10
A2: 20
A3: 30

Formula:
=SUM(OFFSET(A1, 0, 0, 3, 1))
Result: 60