how can I use cell refs to create a multiple "OR" criteria when using COUNTIFS

[hairyfingers]

Hi

If I have this table in cells A1 to C4

Apples 1 yes
Pears 1 no
Oranges 3 no
Plums 4 yes


want to count fruit which have a "1" in col B and a "yes" or "no" in col C using COUNTIFS and an array to create an OR criteria

So like this:

 

[FormR]

Hi, something like this?

Excel 2013/2016
	A	B	C	D	E	F
1	Apples	1	yes		Yes	2
2	Pears	1	no		No
3	Oranges	3	no
4	Plums	4	yes
5	Bananas	1	Other
Sheet1

Cell Formulas
Range	Formula
F1	=SUMPRODUCT(COUNTIFS(B:B,1,C:C,E1:E2))

 

[hairyfingers]

Great, perfect!