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.
<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>
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 |