Sum vs Sumproduct Function in Excel (Video in Khmer)

Hello everyone! Today I show you how to use SUM and SUMPRODUCT formula in Excel step by step with simple examples and video speak Khmer.

You ever want to add numbers together or calculate total revenue in Excel? SUM function is basic formula to add numbers in a range. But what if you have Quantity column and Price column, and you want to calculate total sales without creating extra helper column? Or what if you want to calculate total with multiple conditions? That's when you need the powerful SUMPRODUCT formula!

Let's look at how to use both function below.

1. How to Use SUM Formula in Excel

SUM formula help you add all numbers in a selected range of cells. It is very simple, fast, and easy to use.

Formula Syntax:

=SUM(number1, [number2], ...)

Example:

If you have total sales in cells B2:B5 (100, 200, 150, 50):

• =SUM(B2:B5) ➔ 500

Watch video below for step by step guide in Khmer:

2. How to Use SUMPRODUCT Formula in Excel

SUMPRODUCT formula multiplies corresponding numbers in two or more ranges (arrays), and then sums up the products! It saves you time because you don't need to write Quantity * Price in every row.

Formula Syntax:

=SUMPRODUCT(array1, [array2], [array3], ...)

Example:

Suppose you have Quantity in A2:A4 ([2, 3, 5]) and Price in B2:B4 ([10, 20, 5]):

=SUMPRODUCT(A2:A4, B2:B4)

• Excel calculates: (2 * 10) + (3 * 20) + (5 * 5) = 20 + 60 + 25 = 105

Watch video below for step by step guide in Khmer:

💡 Quick Tip:

• Use SUM when adding up a single column or range of numbers.
• Use SUMPRODUCT when calculating total cost from Quantity and Unit Price columns directly, saving you from creating extra calculation columns!

📚 Useful Resources

• Top 15 Basic Excel Formulas Every Beginner Should Know
• Countif vs Countifs Function in Excel (Video in Khmer)
• How to use MIN vs MAX and SMALL vs LARGE Functions in Excel
• XLOOKUP vs INDEX+MATCH Function in Excel (Video in Khmer)
• Free Download PDF - 50 Popular Excel Formulas Cheatsheet (Khmer Language)