Excel Spreadsheet for Clothing Order
Solved
Micka57
Posted messages
4
Status
Membre
-
plouf92600 Posted messages 3 Status Membre -
plouf92600 Posted messages 3 Status Membre -
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.
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 réponses
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?
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?
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.
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.
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?
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?
There might be possibilities with the IF, THEN functions...
little correction, =nbval(range) gives the number of non-empty cells in the range.