Jump to content


Photo
- - - - -

Bit of help creating item inventory with Excel

Excel

  • Please log in to reply
3 replies to this topic

#1 Voltes_5

Voltes_5

    Total Nerd

  • Members
  • PipPipPipPipPip
  • 2040 posts
  • Gender:Male
  • Location:Kingman, Arizona

Posted 03 May 2017 - 08:19 AM

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.


Asus P8 P67 Pro_i5 25K_RipjawsX 2x4GB_OCZ Vertex 3 128GB_2XZotacGTX 980 Ti AMP SLI_Corsair AX-1200_W7 Home Premium_WD 2TB(Steam)_WD 1TB(Storage)


#2 Gremlin

Gremlin

    Certified Geek

  • Members
  • PipPipPipPip
  • 1694 posts
  • Location:Sacramento, CA

Posted 03 May 2017 - 08:30 AM

I need help with this as well :)  since they wont let us use Access :rolleyes: at work


Gremlin_FLG.png


#3 scr4wl

scr4wl

    R34CT1V4T3D

  • Members
  • PipPipPipPipPip
  • 2988 posts
  • Gender:Male
  • Location:New Mexico

Posted 03 May 2017 - 09:01 AM

The SUM function will be your friend for this: https://support.offi...32-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.


Generic Most Awesome Sig


#4 Voltes_5

Voltes_5

    Total Nerd

  • Members
  • PipPipPipPipPip
  • 2040 posts
  • Gender:Male
  • Location:Kingman, Arizona

Posted 03 May 2017 - 09:09 AM

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, 03 May 2017 - 09:15 AM.

Asus P8 P67 Pro_i5 25K_RipjawsX 2x4GB_OCZ Vertex 3 128GB_2XZotacGTX 980 Ti AMP SLI_Corsair AX-1200_W7 Home Premium_WD 2TB(Steam)_WD 1TB(Storage)