Excel Style Sum: A1 + B1
Result (A1 + B1): 0
📊 How to Calculate the Sum of Two Cells in Excel
✅ Formula to Add Two Cells:
To sum the values of two cells in Excel, use this basic formula:
= A1 + B1
📌 Example:
If A1 = 10 and B1 = 20, typing =A1+B1 in another cell (like C1) will display 30.
🔢 Alternative Using SUM Function:
You can also use the SUM function:
=SUM(A1, B1)
This does the same thing — it adds the values in A1 and B1.
🧠 Tip:
If you want to sum a range (e.g., from A1 to A10), use:
=SUM(A1:A10)
🧰 Common Use Cases:
- Add two price cells:
=Price + Tax - Combine hours worked across two days
- Calculate total marks from two subjects
❓FAQs – Calculating the Sum of Two Cells in Excel
🔹 Can I add cells from different sheets?
Yes! Example:
=Sheet1!A1 + Sheet2!B1
🔹 What if one of the cells is blank?
Excel treats blank cells as 0 in most addition operations.
🔹 What if a cell has text?
You’ll get an error unless the text can be interpreted as a number.