Cell is equal to X but less than XX

New Contributor

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?





Thank you in advance for any assistance you can offer. 

2 Replies
best response confirmed by Hans Vogelaar (MVP)
if you want to equal as well, you need to use "<=" and ">=" instead of "<" and ">" respectively.

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