# Counting by names and weekday

#### Macorden

##### New Member
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.
Code:
``=SUMPRODUCT(--(WEEKDAY(A1:A10)=2))``
This code counts how many times John is in the text.
Code:
``=COUNTIF(B1:B10,"*john*")``
I cant get this one to work.
Code:
``=SUMPRODUCT(--(WEEKDAY(A1:A10)=2),--(COUNTIF(B1:B10,"*john*")))``
Thanks

### Excel Facts

Which lookup functions find a value equal or greater than the lookup value?
MATCH uses -1 to find larger value (lookup table must be sorted ZA). XLOOKUP uses 1 to find values greater and does not need to be sorted.

#### njimack

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

Replies
7
Views
152
Replies
3
Views
413
Replies
1
Views
213
Replies
0
Views
159
Replies
3
Views
177

Threads
1,195,681
Messages
6,011,129
Members
441,586
Latest member
rodsin76

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

### Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

### Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back