Forum Discussion
Cost Calculation
I'm going to disagree with mtarler here. He was going in the right direction, in that the SUMPRODUCT function was not what you really wanted. He used the SUM as what you might have wanted, but if I'm not mistaken, it's really the product, a multiplication, that would give you the desired result.
So that would be =M5*N5
For what it's worth, Excel's basic math functions are basic math functions. https://exceljet.net/excel-formulas-and-functions
SUMPRODUCT is altogether different from, and much more complicated than, what you needed. https://exceljet.net/excel-functions/excel-sumproduct-function. The time may come when you need it; it's powerful in the right context (I just used it a day ago), but more than overkill for what you wanted to do.
See the attached revision of your spreadsheet.
