Count unique values with multiple criteria and exclusions

[AlexandraT]

Hello,

I don't usually have to actually post a question here since I can usually find the answers I need in other posts. However, I am unable to find an answer now.

Here is my sample table:

Colour	Article	Size	Sold
Green	Dress <tbody> </tbody>	2	Apr-15 <tbody> </tbody>
Green	Jumper <tbody> </tbody>	2	Feb-15 <tbody> </tbody>
Green	Jumper <tbody> </tbody>	1	Feb-15 <tbody> </tbody>
Green	Pants <tbody> </tbody>	1	May-15 <tbody> </tbody>
Green	Skirt <tbody> </tbody>	2	May-15 <tbody> </tbody>
Green	Skirt <tbody> </tbody>	1	Apr-15 <tbody> </tbody>
Green	T-shirt <tbody> </tbody>	1	Feb-15 <tbody> </tbody>
Green	T-shirt	2	Feb-15 <tbody> </tbody>
Red	Jumper <tbody> </tbody>	1	May-15 <tbody> </tbody>
Red	Jumper <tbody> </tbody>	2	Mar-15 <tbody> </tbody>
Red	Pants <tbody> </tbody>	1	Apr-15 <tbody> </tbody>
Red	Pants <tbody> </tbody>	2	Feb-15 <tbody> </tbody>
Red	Shorts <tbody> </tbody>	2	Mar-15 <tbody> </tbody>
Red	Skirt	1	May-15 <tbody> </tbody>
Red	Socks	1	May-15 <tbody> </tbody>
Red	Socks	2	May-15 <tbody> </tbody>

<tbody>
</tbody>

Looks a bit silly but it should help with that I need. So what I would need is to know how many types of clothes are green but not red and vice versa. I would also like these split by month. Also, how many green only types of clothes come in both sizes and how many red only types of clothes come in both sizes. Also by month.

To illustrate what I need (without taking into account the month):

Green only	2	(Dress,T-shirt)
Red only	2	(Shorts,Socks)
Red 2 sizes	1	(Socks)
Green 2 sizes	1	(T-shirt)

<tbody>
</tbody>

My data is some thousand rows long but there are 2 colours, 2 sizes and 4 months. There are thousands of types of clothes though.

I don't have any preference how this can be done, be it by additional columns, formula, pivot table or power pivot. But for the life of me I cannot figure it out and I can't seem to find anything online (granted I might not be searching properly).

Any help would be greatly appreciated. Thanks

 

[AlexandraT]

did you mean this which is easily changed by using filters

Count of Article
Sold	Article	Colour	Size	Total
Feb-15	Jumper	Green	1	1
			2	1
		Green Total	2
	Jumper Total			2
	T-shirt	Green	1	1
			2	1
		Green Total	2
	T-shirt Total			2
Feb-15 Total				4
Apr-15	Dress	Green	2	1
		Green Total	1
	Dress Total			1
	Skirt	Green	1	1
		Green Total	1
	Skirt Total			1
Apr-15 Total				2
May-15	Pants	Green	1	1
		Green Total	1
	Pants Total			1
	Skirt	Green	2	1
		Green Total	1
	Skirt Total			1
May-15 Total				2
Grand Total				8

<tbody>
</tbody>

No. You see, on my list, regardless of month, there are both green jumpers and red jumpers. If there are both green and red jumpers, the jumpers do not fit the criteria of articles that are only red but not also green. Same goes for the pants. The t-shirts however are only green. there are no red t-shirts on the list, not in February nor any other month.That is why the t-shirts meet the criteria, Dresses are another one. There are only green dresses on the entire list regardless of month (no red dresses on the list). I hope that makes it clearer.