Filter function using a range of numbers between

[EmmaTM]

Hi,

I am using the following formula which is not working:
=FILTER(Data!A2:Q614,(Data!C2:P614>60.01<71.99))
I only want the data displayed where the numbers are between 60.01 and 71.99
See my original table below.

Thank you

 

[EmmaTM]

Yes please

 

[felixstraube]

Is this what you want?

=LET(d, Data!C2:P614,
md, IF((d>71.99) + (d<60.01), "", d),
f, BYROW(md, LAMBDA(x, SUM(x))),
FILTER(md, f>0)
)

 

[Fluff]

Ok, how about

=LET(f,FILTER(Data!A2:Q614,BYROW(Data!C2:P614,LAMBDA(br,COUNTIFS(br,">60.01",br,"<71.99")))),IF(ISTEXT(f),f,IF((f<=60.01)+(f>=71.99),"",f)))

 

[EmmaTM]

Thank you so much

 

[Fluff]

Glad we could help & thanks for the feedback.