Google Sheets: COUNT.IF over multiple cells

[Wannes]

Hi all,

 

Strange questions and didn't know where to go so I'm puting it down here. Hopefully in the correct place otherwise, please move.

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 		...
Neowin			16/11/2021		Bla bla
Windows			12/11/2021		Meh meh
Microsoft		01/11/2021		Moh moh
Neowin			03/11/2021		Lalalala
Neowin			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
Neowin			06/09/2021		Tripiedipp

 

I would like to know how many records "Neowin" has in the month november. If I use the =COUNT.IFS formula than the return would be 4 as the formula counts 2x Neowin in column A and 2x the month November in column B. I need the result to be 2 because Neowin 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,

W.

[Wannes]

On 17/12/2021 at 12:25, Steven P. said:

No-one?

Thanks for backing me up Steven.  

 

@ranpan I has to be a formula indeed as I need it for further development. The pivot table can't offer what I need (or I can't use it in the way I want to). However, I did manage to solve it with following formula. Not sure if it's the correct one but it offers the results I needed. 

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

 

[Steven P. Administrators]

No-one?

[ranpan]

Does it need to be a formula or can it be a pivot table? I grouped column B by month and added B as value with a counta.