Help using SUMPRODUCT to "COUNTIF" multiple criterion are met.

I'm wanting to create a formula that adds up how many clients we have that searches for a given month (this is input as a date, I want to use this formula to search for specific months) and whether they showed to that appointment or not (this is a drop down where I want it to search for yes). The end result is that with a little tweaking I can find the total number of clients that came in January who showed to their appointments, I can find the total number of clients who came in Februarry and showed to their appointments, etc. Then toss this into a stacked column table to quickly compare the number of clients scheduled (I've already got this function done) with the number of clients who actually showed for each given month.

To add to the chaos:
This is the function I'm currently using to count clients scheduled in a given month.
=SUMPRODUCT(1*(MONTH('Marketing, Day 1, 2019'!U2:U10000)=2))
where marketing, day 1, 2019 is the worksheet within the workbook.

To make progress with this I think we really need to see your workbook.

First make sure to remove any sensitive/proprietary data.

To attach a file, and then click on “GO ADVANCED” and then scroll down to “Manage Attachments” to open the upload window. Choose your file then click on “Upload”, scroll down then click on “Close this window”, then “Submit reply”.

I figured it out just a quick minute ago.
I was using months to count and instead entered it in as a date range and it worked. Here's the formula I used:

=countifs('Marketing, Day 1, 2019'!U3:U,">=1/1/19",'Marketing, Day 1, 2019'!U3:U,"<=1/31/19",'Marketing, Day 1, 2019'!V3:V,"Yes")

Thank-you!!!

I don't think I did anything to help

Can you please mark the thread as solved if you’re all set. To do this select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.