Counting Yes/No in Month Range

[nerdgirl1994]

I need some help with counting the number of Yes/No for a survey in a date range.
Ex: need to know the number of "Yes" and "No" for each month
Audit Date 1 2 3 4 5 6 7 8 9 10
5/5/2013 No Yes No Yes Yes No Yes No Yes Yes5/30/2013No No No No Yes No No No No No6/7/2013 Yes No Yes Yes Yes No No Yes Yes Yes
.
.calcuate as data is entried in spreadsheet.
.
Need formual for totals:
May-2013 Jun-2013 July 2013
Yes:7 Yes:6 Yes:
No:12 No: 3 No:
==============================

I have tried Countifs and SumProducts but can not get it to turn out correctly. It counts the whole spreadsheet.
I have tried this =SUMPRODUCT((YEAR('Monitoring ISP'!A3:A29)=2013)*(MONTH('Monitoring ISP'!A3:A29)=6)*COUNTIFS('Monitoring ISP'!C3:Q10,"Yes")) but rec'd incorrect answer.

Many thanks for help,

[oeldere]

Use a helpcolumn to determine the Yes in the row (do the same for the No).

After that you can use that info for your sumproductformula (or pivot table).