3 deep countifs.

Hi,

Use Sumproduct to find the desire result also use number of month instead of Name

=SUMPRODUCT(--(E2:E180="LODD"),--(H2:H180="Fire"),--(MONTH(A2:A180)=5))

Try this:

In 'Listing' column B change the formula to

Formula:

Please Login or Register  to view this content.

You were relying on Custom date formatting to be read as text. It was still a number.

Then this in 'Stat Sheet' B9:E20

Formula:

Please Login or Register  to view this content.

It returns this:

Row\Col	A	B	C	D	E
8	Month	FIRE	LEO	EMS	FLIGHT
9	JAN	0	8	17	5
10	FEB	3	10	0	0
11	MAR	4	16	0	3
12	APR	1	2	0	0
13	MAY	2	7	0	0
14	JUN	1	10	0	0
15	JUL	0	19	0	0
16	AUG	2	10	0	0
17	SEP	7	16	0	0
18	OCT	5	3	0	0
19	NOV	1	0	0	0
20	DEC	3	1	1	0

Good deal. You're welcome and thanks for the feedback.

I extracted the months with this formula on the Listing worksheet column B

Formula:

Please Login or Register  to view this content.

I then selected all your data and added from the Data tab the FILTERS
Using your criteria and your data. There are no matching records for January/Lodd/Fire for the range specified. Your formula is correct as stated: =COUNTIFS(Listing!B8:B34,"Jan",Listing!E8:E34,"LODD",Listing!H8:H34,"Fire")
Expanded to include all your data. Enter this in B9 and fill across

Formula:

Please Login or Register  to view this content.

	A	B	C	D	E
8	Month	FIRE	LEO	EMS	FLIGHT
9	JAN	0	8	17	5
10	FEB	3	10	0	0
11	MAR	4	16	0	3
12	APR	1	2	0	0
13	MAY	2	7	0	0
14	JUN	1	10	0	0
15	JUL	0	19	0	0
16	AUG	2	10	0	0
17	SEP	7	16	0	0
18	OCT	5	3	0	0
19	NOV	1	0	0	0
20	DEC	3	1	1	0