Jump to content

Bit of help creating item inventory with Excel

Recommended Posts

I need a bit of help and or guidance creating a simple 20/25 item inventory with Excel. There are so many graphs to choose from, lol. I was never very good at it so please anyone proficient with Excel, my knowledge on it is just opening a file and that is it. I just want something that I can add amounts at the end of the day. Thank you in advance.

Share this post

Link to post
Share on other sites

The SUM function will be your friend for this: https://support.office.com/en-us/article/SUM-function-043e1c7d-7726-4e80-8f32-07b23e057f89


You'll probably want to create columns (or rows) for the different items, and rows (or columns) for the different days.


Assuming you choose Columns for the items and rows for the days, your final row can contain the total inventory. You just need each cell in the "total" row, to be the sum of the entire column (minus the part name)


Then as days go by you can add rows as need be (before the "total" row), and just enter positive or negative numbers in the corresponding cells.

Share this post

Link to post
Share on other sites

Thank you sir, it is greatly appreciated. I will do my best and give it a try.


I just watched the video and it is a great tool.

Edited by Voltes_5

Share this post

Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now