1

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

Improve this question
1
  • 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, 2013 at 8:09

1 Answer 1

Reset to default
1

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.

Improve this answer
2
  • I guess all his items are in a single column but without a sample file its hard to tell.
    – nixda
    Feb 12, 2013 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, 2013 at 9:00

You must log in to answer this question.

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