countifs problem

[Lukas C]

[TABLE="width: 297"]
<colgroup><col><col><col></colgroup><tbody>[TR]
[TD]Name[/TD]
[TD]last visit[/TD]
[TD]more booked[/TD]
[/TR]
[TR]
[TD]John[/TD]
[TD="align: right"]01/01/2019[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]John[/TD]
[TD="align: right"]16/01/2019[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]John[/TD]
[TD="align: right"]01/07/2018[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]Chris[/TD]
[TD="align: right"]01/07/2018[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Chris[/TD]
[TD="align: right"]01/08/2018[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]Chris[/TD]
[TD="align: right"]01/01/2019[/TD]
[TD] [/TD]
[/TR]
</tbody>[/TABLE]

looking for formula to count if active person within 30 days or if more that 30 days but have booked appointment also count that person
i used that but is wrong
=COUNTIFS($B$2:$B$7,">"&TODAY()-30,$C$2:$C$7,">0")

 

[FormR]

Hi, you could try:

=COUNTIFS($B$2:$B$7,">"&TODAY()-30)+COUNTIFS($B$2:$B$7,"<="&TODAY()-30,$C$2:$C$7,">0")

 

[Lukas C]

Hi, you could try:

=COUNTIFS($B$2:$B$7,">"&TODAY()-30)+COUNTIFS($B$2:$B$7,"<="&TODAY()-30,$C$2:$C$7,">0")

Thx I already tried that it give we wrong count 4 instead of 5

 

[FormR]

it give we wrong count 4 instead of 5

Hi, it returns 5 for me based on your sample data?

Excel 2013/2016
	A	B	C	D	E
1	Name	last visit	more booked		formula
2	John	01/01/2019	1		5
3	John	16/01/2019
4	John	01/07/2018	1
5	Chris	01/07/2018
6	Chris	01/08/2018	1
7	Chris	01/01/2019
Sheet1

Cell Formulas
Range	Formula
E2	=COUNTIFS($B$2:$B$7,">"&TODAY()-30)+COUNTIFS($B$2:$B$7,"<="&TODAY()-30,$C$2:$C$7,">0")

 

[Lukas C]

yes you are absolutely correct my had ">" instead of "<" .
Many Thx for your help