Countifs with dates

[MarcBeideler]

Hello,

First of all I want you to apologize my bad english, it's not my first language.

My problem:
I have a list with 3 columns and 100 rows.

Column A category with articles named for example X, Y, Z
Column B containing the entry date of the article
Column C containing the exit date of the article

I need now a formula for a table in witch I could count the article X where the difference between entry and exit date is less or equal 1 year.
Please note the the entry dates are different.
Actually I had a formula in a different column where an IF-formula looked in every row if the conditions are true by giving a result or leaving empty but I thought that it would be better without that additional column.

I've tried with DATE(YEAR()+1,MONTH(),DAY() but it doesn't return a result.

Thanks for your help

Unfortunately it's impossible for me to upload a sheet from my work-computer

 

[anand3dinesh]

can you please able to provide us sample data?

 

[MarcBeideler]

Here an image, as it's not possible to upload the file

 

[Snakehips]

@MarcBeideler Does the below help?

Book7
	A	B	C	D
1	Total	X	Y	Z
2	In	0	3	3
3	Out	2	0	0
4	Out 1 Year	2	0	0
5
6
7
8	Category	In	Out
9	X	4/21/21	5/21/21
10	X	4/24/21	4/25/21
11	Y	10/25/22
12	Y	11/21/22
13	Y	11/21/22
14	Z	11/21/22
15	Z	11/21/22
16	Z	11/21/22
17
Counts

Cell Formulas
Range	Formula
B2:D2	B2	=COUNTIFS($A9:$A20,B1,$B9:$B20,">0",$C9:$C20,"")
B3:D3	B3	=COUNTIFS($A9:$A20,B1,$C9:$C20,">0")
B4:D4	B4	=SUMPRODUCT(($A9:$A20=B$1)*($C9:$C20>0)*($C9:$C20<=($B9:$B20+365)))

 

[MarcBeideler]

@MarcBeideler Does the below help?

Book7
	A	B	C	D
1	Total	X	Y	Z
2	In	0	3	3
3	Out	2	0	0
4	Out 1 Year	2	0	0
5
6
7
8	Category	In	Out
9	X	4/21/21	5/21/21
10	X	4/24/21	4/25/21
11	Y	10/25/22
12	Y	11/21/22
13	Y	11/21/22
14	Z	11/21/22
15	Z	11/21/22
16	Z	11/21/22
17
Counts

Cell Formulas
Range	Formula
B2:D2	B2	=COUNTIFS($A9:$A20,B1,$B9:$B20,">0",$C9:$C20,"")
B3:D3	B3	=COUNTIFS($A9:$A20,B1,$C9:$C20,">0")
B4:D4	B4	=SUMPRODUCT(($A9:$A20=B$1)*($C9:$C20>0)*($C9:$C20<=($B9:$B20+365)))

Thank you,

no it don't work.
Result was in my table 0 and it should be 2

Thank you

 

[MarcBeideler]

@MarcBeideler Does the below help?

Book7
	A	B	C	D
1	Total	X	Y	Z
2	In	0	3	3
3	Out	2	0	0
4	Out 1 Year	2	0	0
5
6
7
8	Category	In	Out
9	X	4/21/21	5/21/21
10	X	4/24/21	4/25/21
11	Y	10/25/22
12	Y	11/21/22
13	Y	11/21/22
14	Z	11/21/22
15	Z	11/21/22
16	Z	11/21/22
17
Counts

Cell Formulas
Range	Formula
B2:D2	B2	=COUNTIFS($A9:$A20,B1,$B9:$B20,">0",$C9:$C20,"")
B3:D3	B3	=COUNTIFS($A9:$A20,B1,$C9:$C20,">0")
B4:D4	B4	=SUMPRODUCT(($A9:$A20=B$1)*($C9:$C20>0)*($C9:$C20<=($B9:$B20+365)))

Sorry, I saw my error in the formula, yes it works, thank you