COUNT.IFS over multiple columns

[Ritsuke]

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).

Column A		Column B		Column C 		...
Google			16/11/2021		Bla bla
Windows			12/11/2021		Meh meh
Microsoft		01/11/2021		Moh moh
Google			03/11/2021		Lalalala
Google			02/12/2021		Sololal
Windows			01/09/2021		Lasoldo
Microsoft		06/08/2021		Boe Boe
Windows			07/07/2021		Boe La Bam
Windows			03/04/2021		Shakalaka
Google			06/09/2021		Tripiedipp

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.

[Haluk]

Try this;

=SUMPRODUCT(A$2:A$11="Google";Month(B$2:B$11)=11)

Use comma instead of semicolon depending on your location settings.


If you want to use COUNTIFS;

=countifs(A$2:A$11;"Google";B$2:B$11;">=1/11/2021";B$2:B$11;"<=30/11/2021")

[davsth]

=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

[Ritsuke]

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