Adding ranges with SUM, multiplying with PRODUCT, and performing multi-column weighted computations and conditional matrix totals with SUMPRODUCT.
This lesson is a free preview. No account is needed to read it.
The video for this lesson has not been published yet. The written lesson below is the full material for this session.
Excel ke primary mathematical aggregation functions ka deep-dive.
=SUM(A2:A10): Range ke numbers ko add karta hai. Text aur blank cells auto-ignore hote hain.=PRODUCT(A2:A5): Sabhi numbers ko aapas mein multiply karta hai (A2 * A3 * A4 * A5).SUMPRODUCT matching rows ko multiply karke unka grand total ek hi step mein return karta hai:
=SUMPRODUCT(array1, [array2], ...)
Corporate Billing Example:
| Quantity (Col A) | Unit Price (Col B) |
|---|---|
| 2 | 100 |
| 3 | 200 |
| 4 | 50 |
Bina helper column banaye direct Grand Total:
=SUMPRODUCT(A2:A4, B2:B4)
// (2 * 100) + (3 * 200) + (4 * 50) = 200 + 600 + 200 = 1,000!
Conditional SUMPRODUCT (Advanced):
=SUMPRODUCT((A2:A10="Food") * (B2:B10))
// Sums sales in Col B where Category in Col A is "Food"
[!IMPORTANT] SUMPRODUCT mein sabhi arrays ki row-height exact same honi chahiye (e.g.
A2:A100andB2:B100), warna#VALUE!error aayega.
=SUMPRODUCT(QtyRange, PriceRange) test karein.=SUMPRODUCT(Marks, Credits) / SUM(Credits).Practice live Excel formulas directly in your browser. Real calculation verified by HyperFormula.
Calculate total revenue in cell D6 by summing all items in column D (cells D2 to D5).
Every formula you enter is evaluated by a real spreadsheet engine in your browser — results are not pre-computed.
| # | A | B | C | D |
|---|---|---|---|---|
| 1 | Product | Quantity | Unit Price | Total |
| 2 | Laptop | 5 | 45000 | 225000 |
| 3 | Mouse | 20 | 500 | 10000 |
| 4 | Keyboard | 15 | 1200 | 18000 |
| 5 | Monitor | 8 | 12500 | 100000 |
| 6 | Grand Total |
5 practical questions testing mathematical calculation precision, SUMPRODUCT, and ranking in Excel.
This quiz has 5 questions. Sign in to answer them — results are saved to your account.
Sign in to attemptSign in to submit your work for this assignment.
Stuck on a formula or edge case? Ask questions, upvote solutions, and earn community XP.
No questions yet on this lesson
Be the first to ask a doubt or start a discussion with peers and mentors!
Module 8: Mathematical & Statistical Functions
Module 9: Conditional Functions & Criteria-Based Analysis