Need help counting text attributed to a person for corresponding week & month numbers

I want to know how many times John, Nick and Rambo got "planned" in the corresponding week- and month-numbers.

Hi

Change data in J4:M4 to 6, 7, 8, 9
Change data in J9:L9 to 01/02/2018, 01/03/2018, 01/04/2018 and format as date "mmmm"

Try this formulas in J5 and j12. and copy for the other cells

Formula:

=SUMPRODUCT(($A$3:$A$14=J$4)*(INDEX($C$3:$E$14,0,MATCH($I5,$C$2:$E$2,0))<>""))

Formula:

=SUMPRODUCT((MONTH($B$3:$B$14)=MONTH(J$9))*(INDEX($C$3:$E$14,0,MATCH($I11,$C$2:$E$2,0))<>""))

See the file

Thanks José, it worked perfect!

You are welcome.

Do not forget to mark this thread as SOLVED.

Best regards.

Done. Thanks again, you're the best