Countifs with AND

[psamu]

I am trying to get the countifs by using multiple column. I need to find out the number of times
Column A and Column B. Column A with unique ID and Column B with multiple criteria.
For eg. Coulmn A1 = Apples, Column A2 = Apples
Column B1 = Orange and Column B2 = Peach
Above case count as =2 but if Column B1 Orange, and Column B2 = Orange, then count as 1

 

[VBA Geek]

perhaps you are after this

Excel 2013/2016
	A	B	C	D
1	orange	wine
2	orange	wine		2
3	apples	vinegar
4	orange	wine
5	apples	vinegar
Sheet2

Cell Formulas
Range	Formula
D2	{=SUM(1/(COUNTIFS(A1:A5,A1:A5,B1:B5,B1:B5)))}
Press CTRL+SHIFT+ENTER to enter array formulas.

 

[psamu]

That should count as 1, but if orange and vinager comes it count as 2