=ifna(query(Transactions!$B$1:$R, “select sum(E) where B >= date ‘2020-01-01’and B <= date ‘2020-01-31’ and D = ‘Paycheck’ Label sum(E)’’”, 1),iferror(1/0))
This actually works, but instead of D=‘Paycheck’ (from Spreadsheet A) - I would love to replace the verbiage ‘Paycheck’ with the D=value from cell A3 (of Spreadsheet B). The query resides in Spreadsheet B. That way, I could copy the formula for each row rather than having to change the text for each instance.
There may be a more direct way to accomplish this, but I am trying to return the sum dollars of the category ‘Paycheck’ for the month of January 2020.
Hopefully not too confusing…