Countifs With Months

[kumara_faith]

Hi,

I have the following tables:

Book1
	C	D	E	F	G	H	I	J	K	L	M	N	O
2	Table 1				Table 2					Table 3
3	Branch	Sales Staff	Date		Branch	February	March	April		Branch	February	March	April
4	Texas	Mark	8/2/2022		Texas	0	0	0		Texas	1	0	0
5	Maine	Javier	7/2/2022		Maine	0	0	0		Maine	1	0	0
6	Illinois	Juan	5/4/2022		Illinois	0	0	0		Illinois	0	0	1
7	Iowa	Kenny	5/3/2022		Iowa	0	0	0		Iowa	0	1	0
8	Virginia	Joan	9/4/2022		Virginia	0	0	0		Virginia	0	0	1
Sheet1

Cell Formulas
Range	Formula
H4:J8	H4	=COUNTIFS($C$4:$C$8,$G4,$E$4:$E$8,H$3)

1) Table 1 is the raw data
2) Table 2- I am trying to summarize the count of sales staffs recorded for the branch based on the month. However my current formula is not showing the correct results
3) Table 3 - This is an example of the correct result.

Appreciate any help to modify the current formula to show the desired results.

 

[jtakw]

2 things.
1. I only see one table in your sample.
2. Is this meant for Excel or Google sheets ?

ALSO, see my Post #9.

 

[kumara_faith]

hi,

There is two table and and you choose to download and then can be viewed in Excel ( File >> Download >> Microsoft Excel)

 

[Fluff]

What date system do you use?
If you are using dd/mm/yyyy then none of those dates are in Feb, Mar or Apr

 

[kumara_faith]

Hi Fluff and Jtakw,

Yes, I rectified the date format accordingly and now it works. My apologies for the inconvenience. Thank you for the solution and have a great day.

 

[jtakw]

You're welcome, glad you sorted it out.