Grouping of dates with COUNTIFS

[dmfweb]

I have a spreadsheet (Shocking... I know) with a bunch of dates and data (again... I will let the shock wash over you)

I am using an IF statement to say if "date" is over 3 days ago put YES, if not, put NO same for 10 days, 20 days, and 30 days... All of that works... but when I go to do a count at the end the total is greater than the number of dates because if a date is greater than 10 days it is obviously greater than 3 days and 5 days and it gets counted in each of those columns also.... (see below)
Is there any way to make it only count each row once (the oldest date)

maybe something with lookup formula and some other math between created date and today()? I would rather not go that route...but I am open to anything....

Appreciate any help

	1/3/2023​	12/27/2022​	12/17/2022​	12/7/2022​
15-Dec​	Yes​	Yes​	Yes​	No​
12/31/2022​	Yes​	No​	No​	No​
1-Jan​	Yes​	No​	No​	No​
5-Jan​	No​	No​	No​	No​
12/14/2022​	Yes​	Yes​	Yes​	No​
12/13/2022​	Yes​	Yes​	Yes​	No​
12/12/2022​	Yes​	Yes​	Yes​	No​
12/11/2022​	Yes​	Yes​	Yes​	No​
12/10/2022​	Yes​	Yes​	Yes​	No​
12/9/2022​	Yes​	Yes​	Yes​	No​
12/8/2022​	Yes​	Yes​	Yes​	No​
12/7/2022​	Yes​	Yes​	Yes​	Yes​
12/6/2022​	Yes​	Yes​	Yes​	Yes​
12/18/2022​	Yes​	Yes​	No​	No​
12/16/2022​	Yes​	Yes​	Yes​	No​
Total​	14​	12​	11​	2​

 

[jasonb75]

Use countifs with the maximum, i believe that is ">30" from the description in your post.

For the next one, e.g. ">20" do the same, then subtract the result of the first formula.

Repeat for the rest, each time subtracting the sum of the previous formulas from the count result.

 

[dmfweb]

Use countifs with the maximum, i believe that is ">30" from the description in your post.

For the next one, e.g. ">20" do the same, then subtract the result of the first formula.

Repeat for the rest, each time subtracting the sum of the previous formulas from the count result.

I think that is what I am doing:

=IF(A1<=TODAY()-3, "Yes", "No")

 

[dmfweb]

@jason75

Use countifs with the maximum, i believe that is ">30" from the description in your post.

For the next one, e.g. ">20" do the same, then subtract the result of the first formula.

Repeat for the rest, each time subtracting the sum of the previous formulas from the count result.

I think I misunderstood your post the first time....

I knew that logic would work, but after doing this for so many hours I was doing it backwards... thank you!