SUMPRODUCT: multiply and add at once
Multiply row by row and add it all up, in one formula.
How much is everything in stock worth? Normally you'd do price × quantity on each row and then add it all up.
Module: Tricks with numbers. Lesson 35 of 62.
Multiply row by row and add it all up, in one formula.
How much is everything in stock worth? Normally you'd do price × quantity on each row and then add it all up.
Module: Tricks with numbers. Lesson 35 of 62.