Formula for COUNTIF

[NeoSez]

I am trying to create a formula for countif.
Let's say I have Apples, Oranges, and Pears.
But some are green and some are red.
I would like a count of how many apples are red and how many are green.
Or how many oranges are green or how many are red. etc...
Can someone help me with the formula? Thanks.

 

[Scott Huish]

=COUNTIFS(A:A,"Apple",B:B,"Red")
etc.

 

[BigBeachBananas]

Another way.

Book1
	A	B	C	D	E
1	Apple	Red		Fruit	Apple
2	Apple	Yellow		Color	Red
3	Apple	Pink			1
4	Banana	Red
5	Banana	Yellow
6	Banana	Pink
7	Orange	Red
8	Orange	Yellow
9	Orange	Pink
Sheet4

Cell Formulas
Range	Formula
E3	E3	=SUMPRODUCT(--(A1:A9&B1:B9=E1&E2))

 

[NeoSez]

=COUNTIFS(A:A,"Apple",B:B,"Red")
etc.

Thank you Scott. I was missing the "S" in Countifs. What is the difference between Countif and Countifs? I thought they were the same.

 

[NeoSez]

Another way.

Book1
	A	B	C	D	E
1	Apple	Red		Fruit	Apple
2	Apple	Yellow		Color	Red
3	Apple	Pink			1
4	Banana	Red
5	Banana	Yellow
6	Banana	Pink
7	Orange	Red
8	Orange	Yellow
9	Orange	Pink
Sheet4

Cell Formulas
Range	Formula
E3	E3	=SUMPRODUCT(--(A1:A9&B1:B9=E1&E2))

Thank you for suggesting this as well. I will keep this in mind for the next time.

 

[Scott Huish]

Thank you Scott. I was missing the "S" in Countifs. What is the difference between Countif and Countifs? I thought they were the same.

COUNTIF counts a single condition. COUNTIFS counts multiple conditions