Inventory Spreadsheet

Occasional Visitor



I'm hoping someone can help me as this is beginning to drive me crazy, I can not seem to make it work.


I have an excel inventory spreadsheet.


The first sheet is the master inventory tab, then afterwards there are multiple sheets, all with the same information on but specific to each site.


Im trying to get a formula working so that if i had say 10 traffic cones out on site it would take this away from the available cell on the master sheet.


I managed to get it working for the 1st sheet but then when i added a 2nd sheet, it wouldn't work.


Any ideas?


Thanks so much


1 Reply


Inventory list for Download

Templates Inventories


If this Information dont helps, please ... Give more detailed information about your project.

It is best to insert a file (without sensitive data), where you describe your project step by step on the basis of this file.

( Drag and drop here or browse files to attach
Maximum size: 71 MB • Maximum attachments allowed: 5   )

Inform us about your computer environment, Excel version, operating system, storage medium (hard drive, OneDrive, Sharepoint, tec.).

In this way you can get a solution proposal that is tailored to you much faster and more precisely,

and you save the helpers a lot of time in that they no longer need to guess what-where-how your plan is. Welcome to your Excel discussion space!


Hope I was able to help you with this info.

Thank you for your understanding and patience



I know I don't know anything (Socrates)