Okay, maybe I shouldn't even be using Query, but that's what I've been working with right now:

QUERY($F$7:$J$18;"select sum(G) where (F=TRUE and "&MOD(F$76;J)&">H)";0)

Where F76 is a cell reference and J is a column reference from the query function.

I have two data sets and need to feed one of them with the result of a query from the other one.

Data set 1 has a bunch of stuff related to a time of execution, data set 2 has a bunch of stuff related to time windows. I want to get the sum of a column from set 2 but only select the data where the time window contains the time of execution from set 1.

Thus, QUERY select sum(Column-I-Want-To-Sum) where MOD($Cell-With-Time-Of-Execution;Column-Time-Window)... How can I mix a cell reference and a query reference inside a function inside the query?

The mod function right there need to receive both params, a cell reference from Set 1 and a column reference from Set 2. I just can't figure out how to achieve this. Can anyone help?