Countif Unique combination!!!

[deadlyliquidx]

Hey All,
I need ONE FORMULA to be able to solve a problem that I have to find a product and color of product, and count it once if it shows up once in a span of 3 months but not count it if it shows up in subsequent months.
Now I can do this with a helper column easily but I am trying to find a way to do it without one in one formula.
Attached:

THANKS

 

[Mike Szczesny]

Can you use something like this?

Excel 2012
	A	B	C	D	E	F	G	H	I
1	Month	Type	Sku		Type	Sku		Unique Qty
2	Jan-14	a	1		a	1		7
3		b	1		b	1
4		b	2		b	2
5		c	1		c	1
6					b	3
7	Feb-14	a	1		d	1
8		b	1		c	2
9		b	3
10		d	1
11
12	Mar-14	a	1
13		b	1
14		b	2
15		c	2
16
Sheet1

Cell Formulas
Range	Formula
E2	{=INDEX($B$2:$B$15,SMALL(IF(FREQUENCY(IF($B$2:$B$15<>"",IF($C$2:$C$15<>"",IF(MONTH($A$12-$A$2)+1<=3,MATCH($B$2:$B$15&$C$2:$C$15,$B$2:$B$15&$C$2:$C$15,0)))),ROW($B$2:$B$15)-ROW($B$2)+1),ROW($B$2:$B$15)-ROW($B$2)+1),ROWS($E$2:E2)))}
F2	{=INDEX($C$2:$C$15,SMALL(IF(FREQUENCY(IF($B$2:$B$15<>"",IF($C$2:$C$15<>"",IF(MONTH($A$12-$A$2)+1<=3,MATCH($B$2:$B$15&$C$2:$C$15,$B$2:$B$15&$C$2:$C$15,0)))),ROW($C$2:$C$15)-ROW($C$2)+1),ROW($C$2:$C$15)-ROW($C$2)+1),ROWS($F$2:F2)))}
H2	{=SUM(IF(FREQUENCY(IF($B$2:$B$15<>"",IF($C$2:$C$15<>"",IF(MONTH($A$12-$A$2)+1<=3,MATCH($B$2:$B$15&$C$2:$C$15,$B$2:$B$15&$C$2:$C$15,0)))),ROW($B$2:$B$15)-ROW($B$2)+1),1))}
Press CTRL+SHIFT+ENTER to enter array formulas.