CountIF with Rolling Months

[nburaq]

Hi,
I have a data shown below, my aim is to count the data with condition last 12 rolling months. Here is the simple data

Datum	Location1
Jan/22	43,70
Feb/22	2,24
Mar/22	28,96
Apr/22	25,57
May/22	41,19
Jun/22	37,42
Jul/22	41,88
Aug/22	37,37
Sep/22	39,31
Oct/22	38,79
Nov/22	37,91
Dec/22	40,40
Jan/23	74,69
Feb/23	59,99
Mar/23	60,69
Apr/23	60,69
May/23	52,00
Jun/23
Jul/23
Aug/23
Sep/23
Oct/23
Nov/23
Dec/23

Normally I achieve this with COUNTIF(Range; ">30") but I dont know how can I achieve this with rolling months.
Thanks for your help !

 

[Fluff]

How about

Fluff.xlsm
	A	B	C	D
1	Datum	Location1
2	Jan-22	43.7		12
3	Feb-22	2.24
4	Mar-22	28.96
5	Apr-22	25.57
6	May-22	41.19
7	Jun-22	37.42
8	Jul-22	41.88
9	Aug-22	37.37
10	Sep-22	39.31
11	Oct-22	38.79
12	Nov-22	37.91
13	Dec-22	40.4
14	Jan-23	74.69
15	Feb-23	59.99
16	Mar-23	60.69
17	Apr-23	60.69
18	May-23	52
19	Jun-23
20	Jul-23
21	Aug-23
22	Sep-23
23	Oct-23
24	Nov-23
25	Dec-23
Master

Cell Formulas
Range	Formula
D2	D2	=SUM(IF(TAKE(FILTER(B2:B25,B2:B25<>""),-12)>30,1,0))

 

[nburaq]

Amazing! Millions times thanks!

 

[Fluff]

You're welcome & thanks for the feedback.

 

[nburaq]

Regarding this formula, can I use this part =TAKE(FILTER(B2:B25,B2:B25<>""),-12)>30 for conditional formatting?

 

[Fluff]

Yes, but it will probably not do what you want.

 

[nburaq]

Yes, but it will probably not do what you want.

Tried and approved I wanted to highlight those values but I assume it will require a new topic. Thanks again for all your help

 

[Fluff]

You're welcome.