Inventory Management Question

Hello everyone,

For the past year, I've been managing my dad's business expenses in a way that I don't find productive anymore. I'd like to switch up the way I keep records of the expenses but I have a question on setting up the formula. Here is what I want to do,

I'll have columns for ITEM, QTY, PRICE, TOTAL PRICE, & CATEGORY.

So if the particular item falls under, let's say "Dairy", then whatever the TOTAL PRICE is added in another cell on the side of the same or new workbook. (i.e., We have Milk, Cheese, and Yogurt under the "Dairy" CATEGORY, each costing $1.99 & Lettuce, Cucumber, and Tomatoes under the "Vegetables" CATEGORY, each costing $1.29. Then, on the side, next to "Dairy" it would say $5.97 and $3.87 next to "Vegetables" where I'll have Totals for each category.

I'm pretty sure this would be done with IF, AND, and maybe even COUNT statements/formulas but I have no clue on how to set it up.

Hopefully this makes sense. If not, I can try to clarify more with an actual spreadsheet.

Thanks for the help.

EDIT: I tried Googling the solution but I had no luck. Probably because I didn't know what to properly search for.

Originally Posted by Spencer101

Hi,

Look into SUMIFS. It's exactly what you need or this.

You could also use pivot tables.

Hope that helps.
Let me know if you need more help.

S.

Perfect. Thank you!