Extract data by month and year

I have a large 2 column data set that contains date & time and their corresponding values recorded every 15 minutes (mm-dd-yy h:mm format) for multiple years. I need to create a table that counts the number of data points >zero by month for each year. I titled and formatted the table columns by date, Jan-2020, Feb-2020, etc. off to the side in row 9. I want to search the data set based on the month and year of the column title. I have tried both of the following but get 0 (zero) as a result.

=COUNTIFS($D$10:$D$35049,"="&DATE(YEAR(P$9),MONTH(P$9),1),F10:F35049,">0")
=COUNTIFS($D$10:$D$35049,"="&MONTH(Q$9),$D$10:$D$35049,"="&YEAR(P$9), F10:F35049,">0")

Where dates for the data are in column D, the data are in column F, and row 9 is the targeted month and year, which is column P in this example.

Is there another way to do this?

Welcome to the forum.

There are instructions at the top of the page explaining how to attach your sample workbook. Screenshots are of little practical use as we cannot manipulate them.

A good sample workbook has just 10-20 rows of representative data that has been desensitised. It also has expected results mocked up, worked examples where required, relevant cells highlighted and a few explanatory notes.

Choose the file - upload it - close the upload window and don’t forget to save.

1 Mb for .xlsx. It used to be higher for .xlsb, but I'm not sure that works.

Anyway... it's a SAMPLE we want, 10-20 rows, not THOUSANDS,

One way (of many):

=COUNTIFS($C:$C,TEXT(P9,"mmm-yy"),$F:$F,">0")

see file.

One you find us... you cannot leave. there is no escape.

Anyhow...

You're welcome.

---

It would be very nice if you were to just click the Add Reputation button at the foot of any of the posts of members who helped you reach a solution.

Finally, if that takes care of your original question, please click on "Thread Tools" from the menu link (just above the first post in the thread) and mark this thread as SOLVED.