Formula to count based on dates and text in multiple cells - See Spreadsheet

try in E3
=SUMPRODUCT(--(E8:E17<>""),--(MONTH(E8:E17)=MONTH(E3)))

this will count the months in column E that match , assuming only Yes and No can exist

in F3
put
=SUMPRODUCT(--(E8:E17<>"")*(MONTH(E8:E17)=MONTH(E3))*(F8:F17="yes"))

and then change the last section for each other column

in E3 change the list to use dates and then format to just display the month

only issue will be if you want different years

your welcome

i didnt complete the E3 list of dates , if using my example sheet

if my assistance has helped, and only if you wish to , there is a reputation icon * on the left hand side - you can add to my reputation here
If you have a solution to your thread - Please mark your thread solved do the following: >
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.