Countifs to find year from Date

[kjonesie07]

Looking for a formula for 3 criteria in excel to count if all are TRUE:

Number of entries that equal a specific region
Number of entries that say "Yes"
Number of entries that have a date submitted in 2024

Column A is the Regions: Eastern, Western, Southern
Column B is Accepted, with Yes or No in the cells
Column C is Date Submitted (date format is MM/DD/YY)

I would like to know how many Accepted entries there were for the Western Region in 2024.

 

[Eric W]

Try:

Book1
	A	B	C	D	E	F	G	H
1	Region	Accepted	Date		Region	Accepted	Year	Count
2	Eastern	Yes	1/1/2023		Western	Yes	2024	0
3	Western	No	2/15/2024
4	Southern	Yes	6/7/2024
5	Eastern	Yes	6/8/2024
6	Western	No	6/9/2024
7	Southern	Yes	6/10/2024
8	Eastern	Yes	1/1/2023
9	Western	No	2/15/2024
10	Southern	Yes	6/7/2024
11	Eastern	Yes	1/1/2023
12	Western	No	1/1/2022
13	Southern	Yes	6/7/2024
Sheet4

Cell Formulas
Range	Formula
H2	H2	=COUNTIFS(A2:A13,E2,B2:B13,F2,C2:C13,">="&DATE(G2,1,1),C2:C13,"<="&DATE(G2,12,31))

 

[kjonesie07]

Try:

Book1
	A	B	C	D	E	F	G	H
1	Region	Accepted	Date		Region	Accepted	Year	Count
2	Eastern	Yes	1/1/2023		Western	Yes	2024	0
3	Western	No	2/15/2024
4	Southern	Yes	6/7/2024
5	Eastern	Yes	6/8/2024
6	Western	No	6/9/2024
7	Southern	Yes	6/10/2024
8	Eastern	Yes	1/1/2023
9	Western	No	2/15/2024
10	Southern	Yes	6/7/2024
11	Eastern	Yes	1/1/2023
12	Western	No	1/1/2022
13	Southern	Yes	6/7/2024
Sheet4

Cell Formulas
Range	Formula
H2	H2	=COUNTIFS(A2:A13,E2,B2:B13,F2,C2:C13,">="&DATE(G2,1,1),C2:C13,"<="&DATE(G2,12,31))

Thank you so much, that worked!

 

[Eric W]

Happy to help!