Excel Study · Module 4: Counting & summing with conditions
Class 35SUMPRODUCT: weighted totals
Intermediate2:08 videoFree
A café bill: each item has a price and a quantity. The long way multiplies every row in a helper column and then adds them up.
Try this AI prompt
Works in ChatGPT, Gemini, Copilot or Claude.
In Excel, B2:B6 has the price of each item and C2:C6 the quantity ordered. Write one formula for D9 that gives the total bill: each price times its quantity, all added up.
The answer that works
✓ checked in Excel=SUMPRODUCT(B2:B6,C2:C6)
AI can get Excel wrong. Paste its answer into Excel and test it before you trust it.