TTEST with non-contiguous range

I am trying to perform a TTEST on conditional values that are non-contiguous. I am working off of a master sheet that has all my data and need to sort it conditionally (>0 & < 15, >15 & <45, >45 & <90, etc.). I have not found a way to do this using built-in excel functions.

Additionally, I have tried to create a macro that will copy the master sheet to a new worksheet then filter it to the desired conditions, but when I perform the TTEST, it uses ALL the data entries, not just the desired filters entries and therefore returns a useless TTEST.

Ideally I would like to just be able to input the data into my master sheet and then have all other sheets conditionally updated automatically.

Any help would be greatly appreciated.

An array works when I use a single condition IF function, but in some of my calculations I have multiple conditions that I need to evaluate:
1. 0 < x < 8
2. 8 < x < 22
3. 22 < x < 35
4. etc.

When I try:
{=TTEST(IF(AND(G:G>0,G:G<15),I:I ),IF(AND(G:G>14,G:G<45),I:I ),2,3)}

I just get #VALUE!

I have attached a sample worksheet attempting to demonstrate what I am trying to do.

Any help in solving this dilemma would be greatly appreciated.

Thanks!