Forum Discussion
Formula Help To calculate inventory
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 i...
Bennadeau Thank you so much for your help!!! This will be so much easier than the way I have it currently set up! You're awesome!
As variant you may use PivotTable on last two columns filtering the blank on category. That's only to refresh when source data is changed.