Cell is equal to X but less than XX

[Allan_Hay]

Hi Everyone, 

I hope someone can help ia currently using the below formula to reference a range of data in a separate sheet. The below formula show a list of data from the separate sheet where data in the "G" column is greater than 15. I need to extend on this and only show data that is greater than 15 bu less than 30?

=FILTER(DATA!A2:G201,DATA!G2:G201>15)

Thank you in advance for any assistance you can offer. 

[#2 · Accepted solution]

=FILTER(DATA!A2:G201,(DATA!G2:G201>15)*(DATA!G2:G201<30))
if you want to equal as well, you need to use "<=" and ">=" instead of "<" and ">" respectively.

[#3]

@Sekoleyte Thank you so much, makes so much sense now i see it.