View original (French)

Excel Spreadsheet for Clothing Order

Solved
Micka57 Posted messages 4 Status Member -  
plouf92600 Posted messages 3 Status Member -
Hello,
I am looking for a table that I could use to place an order for clothing.
Let me explain: I need to create a table with the names of the employees in my company and the type of clothing.
I’ve already created a small draft, but I would like it to be done automatically.

In the first column, I have included the names of the hundred employees, and from the second to the fifth columns, I have listed "jumpsuit," "jacket," "pants," and "shoes." Next to each name, I enter the size that each one wishes to order.

Next, I need to create an order sheet, and that’s where things get tricky.. I would like to be able to tally the orders by size.. for example, I would like to know how many jackets in size 40 or 44 need to be ordered, or how many pants, etc., etc...

For that, I would like to be able to count the sizes by column if possible.
If not, I will settle for counting them one by one, hoping not to make a mistake. I don’t want to forget to order 1 or 2 items from an order of 100.

I am using Excel 2003 for your information.

Thank you in advance and long live the forum.
Configuration: Windows XP Firefox 2.0.0.12

5 answers

  1.
    tompols Posted messages 1273 Registration date   Status Contributor Last intervention   460
     
    Good evening,
    I imagine that when you don’t have any order, the cell is empty... If that's the case, try the formula =counta(range)...
    Tom
    2
    1. Micka57 Posted messages 4 Status Member
       
      The function =COUNT(range) just counts the number of elements in a data range... for example, if I select 4 blocks from B5 to B9, I enter the command formula and it gives me 4.

      There might be possibilities with the IF, THEN functions...
      0
      1. tompols Posted messages 1273 Registration date   Status Contributor Last intervention   460 > Micka57 Posted messages 4 Status Member
         
        Re,
        little correction, =nbval(range) gives the number of non-empty cells in the range.
        0
  2. LatelyGeek Posted messages 1774 Registration date   Status Member Last intervention   550
     
    A simple and effective solution: The Pivot Table.

    You select your data table, create a Pivot Table Report (Data Menu) with the pants as row headers and the names as data.
    It will automatically count the people by pant size.

    And you do one for each type of clothing. That gives you 5 tables, but it's super easy...

    If that doesn't work for you, we'll find something else!

    --
    Why complicate life by keeping things simple, when it's so easy to make things complicated?
    0
    1. Micka57 Posted messages 4 Status Member
       
      It could work.. I’ll test it tomorrow!
      Thank you both for responding quickly. I’ll keep you posted soon.
      0
      1. Micka57 Posted messages 4 Status Member > Micka57 Posted messages 4 Status Member
         
        I found a solution on this site http://bvrve.club.fr/Astuces_Michel/201excel.php you need to use the formula =COUNTIF(range; "value")
        That's exactly what I was looking for..you just need to replace the "value" with what you want.

        The site is worth a visit, all Excel formulas are listed there. I found it in another thread on this forum.

        Thank you for your help.
        0
  3. LatelyGeek Posted messages 1774 Registration date   Status Member Last intervention   550
     
    Perfectly, with just one clarification:
    You're going to calculate the number of pants in sizes 36, 38, 40, 42, and 44, for example, with as many COUNTIFs as there are known sizes.

    If a little guy who wears size 34 or a big guy who wears size 46 joins the team, their pants will never be ordered!!!

    So with the pivot table, if...
    --
    Why complicate things by making them simple when it’s so easy to make them complicated?
    0
  4. Justine59139 Posted messages 13 Status Member
     
    Hello, I'm in the same situation as you, but I can't do it... yet I used the formula you provided below... it doesn't work for me.

    Do you have another solution?

    Thank you.
    0
  6. plouf92600 Posted messages 3 Status Member
     
    Hello,
    I am exactly in the same situation as Micka and I am not an Excel expert at all. How did you create the document?
    Thank you.
    Best regards,
    0