•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Simple Inventory In-Out Sheet
Where have I gone wrong here? How can I make the balance of the eggs from this example read "1"? I was using a different function previously - ex.:
=SUMIF(B6:B200,H6,C6:C200)-SUMIF(E6:E200,H6,F6:F200)
The problem I had was that the range was static and would move as I added rows so I would have to manually move the top of the range up to the first row and move the bottom of the range down.
I don't use excel much I just need this simple balance sheet for keeping track of inventory, ideally minimizing the amout of manual labour I have to put into it (lol) any help would be greatly appreciated.
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#Excel alternatives for data analysis
#rows.com
#Excel compatibility
#Excel alternatives
#natural language processing for spreadsheets
#generative AI for data analysis
#row zero
#Excel
#inventory
#balance sheet
#SUMIF
#tracking
#static range
#function
#data range
#spreadsheet
#manual labour
#rows
#top of the range
#bottom of the range