Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I need to create excel sheet of inventory list. I have a given list of items (laptop, monitor, keyboard, etc..) and a group of people.
I saw it is called data validation.
my question is how can i sum the number of monitors the organization has, and how can i sort the items of a certain person.

thanks

share|improve this question
    
This is where spreadsheets stop and databases should begin. If your expecting any kind of growth you'll need a database version sooner rather than later. There are templates like: office.microsoft.com/en-gb/templates/… to help you get started. – cjb110 Feb 12 '13 at 8:09
up vote 1 down vote accepted

A very simple example would be a simple table with your staff on the left one on top of the other and the items on the top. For each member of staff that has a specific item put the number of items they have in the applicable cell. The use SUM() to calculate the total number of each item...

enter image description here

Here item 1 could be the number of laptops each person has, person 3 having 2. Item 2 could be the number of monitors each person has and item 3 the number of mouse's each person has.

You can replace the blank cells with a 0 without it changing the results.

share|improve this answer
    
I guess all his items are in a single column but without a sample file its hard to tell. – nixda Feb 12 '13 at 9:27
    
His first line indicates that he has only the raw information atm ("I need to create...") so my guess was that he could just set up a spread sheet like my example above and enter the info as read from his raw material. But as you said, without more information there is no way to know. – Kevin Anthony Oppegaard Rose Feb 13 '13 at 9:00

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .