Hello! I have an inventory sheet (sample attached) where I need to calculate the total cost of each category (ie. beer, wine, liquor). The challenge is that for ease of taking inventory the sheet isn't set up where all beer is together, all wine is together, etc. Instead, its by supplier. So, I have a column where it take total count X price and gives me my inventory cost for each line item (ie. White Claw Berry, White Claw Mango, etc.) Then I have a column that identifies the line item as beer, wine or liquor.
To get my total costs by category (beer, wine and liquor) I need to add up all beer line items, all wine line items etc. I am doing this manually via inputting a formula each week... basically =sum(_)+sum()+Sum()... its very tedious.
I assume there is a way to put a formula in a cell and say add up all the wine, add up all the beer, etc. ??
Any help on how I can do this would be greatly appreciated. It will make the process so much easier for me. When you look at the file you'll see what I'm wanting to do more easily. Thanks!!!
