Discussion Re: Cost Calculation in Excel
https://techcommunity.microsoft.com/t5/excel/cost-calculation/m-p/2783030#M115271
just use SUM or + instead of SUMPRODUCT.<BR />= M5 + N5<BR />=SUM(M5,N5)Fri, 24 Sep 2021 18:04:22 GMTmtarler2021-09-24T18:04:22ZCost Calculation
https://techcommunity.microsoft.com/t5/excel/cost-calculation/m-p/2782901#M115267
<P>Hi I am trying to make an Inventory spreadsheet for my company to track Inventory and the costs of supplies. For the cost calculation I am confused why the Column O says #VALUE!</P>Fri, 24 Sep 2021 17:19:00 GMThttps://techcommunity.microsoft.com/t5/excel/cost-calculation/m-p/2782901#M115267Sam_Orouji2021-09-24T17:19:00ZRe: Cost Calculation
https://techcommunity.microsoft.com/t5/excel/cost-calculation/m-p/2783030#M115271
just use SUM or + instead of SUMPRODUCT.<BR />= M5 + N5<BR />=SUM(M5,N5)Fri, 24 Sep 2021 18:04:22 GMThttps://techcommunity.microsoft.com/t5/excel/cost-calculation/m-p/2783030#M115271mtarler2021-09-24T18:04:22ZRe: Cost Calculation
https://techcommunity.microsoft.com/t5/excel/cost-calculation/m-p/2783152#M115274
<P><LI-USER uid="1165900"></LI-USER> </P><P> </P><P>I'm going to disagree with <LI-USER uid="570951"></LI-USER> 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.</P><P> </P><P>So that would be <STRONG>=M5*N5</STRONG></P><P> </P><P>For what it's worth, Excel's basic math functions are basic math functions. <A href="https://exceljet.net/excel-formulas-and-functions" target="_blank" rel="noopener">https://exceljet.net/excel-formulas-and-functions</A></P><P>SUMPRODUCT is altogether different from, and much more complicated than, what you needed. <A href="https://exceljet.net/excel-functions/excel-sumproduct-function" target="_blank">https://exceljet.net/excel-functions/excel-sumproduct-function</A>. 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.</P><P> </P><P>See the attached revision of your spreadsheet.</P>Fri, 24 Sep 2021 18:37:39 GMThttps://techcommunity.microsoft.com/t5/excel/cost-calculation/m-p/2783152#M115274mathetes2021-09-24T18:37:39ZRe: Cost Calculation
https://techcommunity.microsoft.com/t5/excel/cost-calculation/m-p/2783218#M115280
Good catch my friend. My brain was out to lunch. So yes, as you noted, it is same answer as before except use either PRODUCT() or *<BR />Fri, 24 Sep 2021 18:47:51 GMThttps://techcommunity.microsoft.com/t5/excel/cost-calculation/m-p/2783218#M115280mtarler2021-09-24T18:47:51ZRe: Cost Calculation
https://techcommunity.microsoft.com/t5/excel/cost-calculation/m-p/2783629#M115302
<P><LI-USER uid="1165900"></LI-USER> </P><P>If you are using Excel tables, why not size them correctly to the data they contain. The equation using structured references would then fill down to match the price and quantity information.</P><LI-CODE lang="excel-formula">=[@PricePerUnit]*[@TotalUnits]</LI-CODE>Fri, 24 Sep 2021 21:22:51 GMThttps://techcommunity.microsoft.com/t5/excel/cost-calculation/m-p/2783629#M115302Peter Bartholomew2021-09-24T21:22:51Z