COUNT.IFS over multiple columns

Hi all,

I have a Google Sheets document filled with raw data and would like to know per company name how many records they have published, between certain dates (= per month).

Please Login or Register  to view this content.

I would like to know how many records "Google" has in the month november. If I use the =COUNT.IFS formula than the return would be 4 as the formula counts 2x Google in column A and 2x the month November in column B. I need the result to be 2 because Google has 2 records in november. If I were to do the same excercise for Microsoft the result would be 1.

Anyone an answer to my, probably, simple question?

Thanks,
R.

=SUMPRODUCT((A$2:A$11="Google")*(MONTH(B$2:B$11)=11))
or
=SUMPRODUCT((A$2:A$11="Google")*(MONTH(B$2:B$11)=11)*(YEAR(B$2:B$11)=2021)) if beyond one year

Thank you very much for the assistance both. I worked with the COUNTIFS as suggested by Haluk.