Counting by names and weekday

[Macorden]

I have a formula I cant figure out. I have them working separately, but not together.

This code works to count the number of times a specific weekday shows up. In this example I am counting the number of times Monday shows up.

=SUMPRODUCT(--(WEEKDAY(A1:A10)=2))

This code counts how many times John is in the text.

=COUNTIF(B1:B10,"*john*")

I cant get this one to work.

=SUMPRODUCT(--(WEEKDAY(A1:A10)=2),--(COUNTIF(B1:B10,"*john*")))

Thanks

 

[njimack]

=sumproduct(--(weekday(a1:a10)=2),--(isnumber(search("john",B1:B10)))