Need to countif with no duplicates and greater than 0.

[deadlyliquidx]

Hello Guys!
I have a problem in which I need to count unique/ distinct (i dunno which one), values that do not duplicate and have a sold value greater than 0 for a certain month.
Ex:

Month	Animal	Sold
JAN	Dog	1
JAN	Dog	1
JAN	Cat	1
JAN	Man	0
FEB	Cat	1
FEB	Dog	1
FEB	Cat	1
FEB	Cat	1
FEB	Man	0
FEB	Man	0
FEB	Ant	1
FEB	Spider	1
FEB	Spider	1
Mar	Dog	0
Mar	Dog	0
Mar	Dog	0
Mar	Dog	0
Mar	Dog	0
Mar	Dog

<colgroup><col><col><col></colgroup><tbody>
</tbody>

 

[AhoyNC]

Like this?

This is an array function and must be entered with

Excel Workbook
	A	B	C	D	E	F
1	Month	Animal	Sold
2	JAN	Dog	1		Month	JAN
3	JAN	Dog	1		Count	2
4	JAN	Cat	1
5	JAN	Man	0
6	FEB	Cat	1
7	FEB	Dog	1
8	FEB	Cat	1
9	FEB	Cat	1
10	FEB	Man	0
11	FEB	Man	0
12	FEB	Ant	1
13	FEB	Spider	1
14	FEB	Spider	1
15	Mar	Dog	0
16	Mar	Dog	0
17	Mar	Dog	0
18	Mar	Dog	0
19	Mar	Dog	0
20	Mar	Dog
CTRL-SHIFT-ENTER.

 

[deadlyliquidx]

Thanks alot, you guys are great

 

[AhoyNC]

You're welcome. Thanks for the feedback.