Count or SUMIF question

First, it is recommended you change the row 2 month titles to actual dates (use the 1st of each month). You can format these to show just the month if desired.

Then use formula in B3:

=COUNTIFS(Data!$A$2:$A$32,">="&B$2,Data!$A$2:$A$32,"<="&EOMONTH(B$2,0),Data!$B$2:$B$32,$A3,Data!$C$2:$C$32,"Yes")

copied across and down.
 
That's brilliant. Thank you sooooooo much, really appreciate the help. Sorry for not knowing the rules before. First time :)
 
Please make sure that you show how the issue was resolved on the other forum.
 
You must log in or register to reply here.
Back
Top