Countifs?

[hp75150]

I have the sample sheet below. I need to count how many y's and n's there are for each ad week per store. I tried a few different countifs with no luck. Any help is appreciated.

1	A	B	C
2	Ad Week	Store #	Y/N
3	1910	205	y
4	1910	205	n
5	1910	205	y
6	1915	205	n
7	1915	205	y
8	1915	205	n
9	1910	215	n
10	1910	215	y
11	1910	215	n
12	1915	215	n
13	1915	215	y
14	1915	215	n

<colgroup><col width="22" style="width: 17pt; mso-width-source: userset; mso-width-alt: 804;"> <col width="73" style="width: 55pt; mso-width-source: userset; mso-width-alt: 2669;"> <col width="64" style="width: 48pt;" span="2"> <tbody> </tbody>

 

[tyija1995]

Hey,

In cell D2 type "Yes" and cell E2 type "No" then add the following 2 formulas:

Try in cell D3:
=SUMPRODUCT(($A3=$A$3:$A$14)*($B3=$B$3:$B$14)*($C$3:$C$14="y"))

And then in E3:
=SUMPRODUCT(($A3=$A$3:$A$14)*($B3=$B$3:$B$14)*($C$3:$C$14="n"))

 

[Fluff]

How about

Excel 2013/2016
	A	B	C	D	E	F
1	Ad Week	Store #	Y/N		1910	205
2	1910	205	y	y	2
3	1910	205	n	n	1
4	1910	205	y
5	1915	205	n
6	1915	205	y
7	1915	205	n
8	1910	215	n
9	1910	215	y
10	1910	215	n
11	1915	215	n
12	1915	215	y
13	1915	215	n
Scratch

Cell Formulas
Range	Formula
E2	=COUNTIFS($A$2:$A$13,$E$1,$B$2:$B$13,$F$1,$C$2:$C$13,$D2)

 

[Marcelo Branco]

Pivot Table?

Counting of Y/N​		Y/N​
Ad Week​	Store #​	n​	y​	Grand Total​
1910​	205​	1​	2​	3​
1910​	215​	2​	1​	3​
1910 Total​		3​	3​	6​
1915​	205​	2​	1​	3​
1915​	215​	2​	1​	3​
1915 Total​		4​	2​	6​
Grand Total​		7​	5​	12​

<tbody>
</tbody>

M.

 

[hp75150]

Thanks