how to add up in excell total number of inventory & price then totals

Hello CT. If you wish to develop a workable Excel inventory spreadsheet, you could structure it so that each product amount is in separate columns. For example, if you had 50 pieces in Column I , 20 pieces in Column K, and 10 pieces in Column L, you would then use the formula = I5 + K5 + L5 to give you the number of units in a separate column. If Column M has the unit price, you'd use = N5 * M5 to find the total stock value for each product. In the case where you are aggregating product data from different warehouse spreadsheets, you should use formulas like SUMIFS that count the product IDs on each sheet and sum their quantities and total values to a summary spreadsheet. This way you have a consolidated and orderly total of all inventories, even if they are spread across multiple locations. If you have about 50 SKUs, and you set each sheet up with an Excel Table, you can keep things neat and tidy while making your formula look tidy in each spreadsheet.

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Best regards,

Hi,

Explore working with Pivot Tables and the GROUPBY() function.

How do I use Pivot tables & Group func

please see attached this is what we need but

here we go