I am looking for your Google Sheets expertise.
I’m trying to combine ARRAYFORMULA, VLOOKUP, QUERY together.
If I take off the “AND Col1 <= DATE '”&TEXT(F2:F,“yyyy-mm-dd”)&" " part it works perfectly, but if I do want to include it, the first row is the only row that works as expected.
“SELECT Col1, SUM(Col2) WHERE Col1 >= DATE '”&TEXT(E2:E,“yyyy-mm-dd”)&“’ AND Col1 <= DATE '”&TEXT(F2:F,“yyyy-mm-dd”)&“’ GROUP BY Col1”,
In arrayformula, you can’t use AND logic… use * to multiply values… if the result is not 0… then it is a match…
also… arrayformula will not work with filters (it will only process the first value)… as @gvalero said, you have to create workaround using vlookups and if formulas
So you log all your incomes into table A, and table B is where you want to combine those logs into certain periods grouped by category? Is “Expected income” the column where the formula should be used?