Use of wildcards in countifs formula

I have created a userform in Excel 2010 that uses countifs on a regular basis. These include print command buttons to cover many years ahead. I have now been asked to include print buttons to cover the months January to December. In the worbook I have a separate sheet to cover each year and that is straightforward. By using only the day/month can I use a countifs with a wildcard for the year to enable the print?

The quick answer is yes, but you'll have to convert the year numbers into text (say A1:A10), and do COUNTIFS(A1:A10, "201*") to count how many years are in between 2010 and 2019.

wip Sessions monthly print.xlsm
If you look at the userform you will understand what I am looking for.
Password to enter Reports/workbook is "password"
The above app is so successful for its purpose, they have asked me to extend the print/report options. I am now past my use by date and trying to retire. Just need to get this up and running by the end of the week. any help is really appreciated. Thanks

Noted - I would use a SUMPRODUCT instead of dealing with COUNTIFS here. That is...

Enter January February March etc. in P1:P12 then

in Monthly sheet B2, enter and copy down.

Formula:

Please Login or Register  to view this content.

Or see attached.

beautiful thank you very much I would not have thought of that!