Hello, I am using Tiller to automatically track my income and expenses into the net worth tracking spreadsheet I use. Unfortunately, the query functions I have tried only give me the results for this month’s (February 2024) and only when the formula calls for January’s expenses. The two query func…

Hey @tilleruser1 , you’ve run into one of the many quirks of the Google Sheets query language: months run from 0 (January) to 11 (December). Try rewriting your query for January using MONTH(I) = 0 and for December using MONTH(I) = 11. The result you get using MONTH(I) = 1 will be for February. In yo…

Using Query function to sum transactions by category and month

Google Sheets

yossiea February 18, 2024, 4:58am 6

It might be easier for you to use built in solutions. See if the Transaction Tracker for Google Sheets helps out.

Topic		Replies	Views
Using a Transactions Query to Generate your Categories Budget Show & Tell showtell-votes	6	896	December 6, 2021
Basic formula in google sheets Google Sheets	6	401	April 22, 2024
Review Last Month's Category Actuals in the Categories Sheet Show & Tell budgeting	2	808	September 9, 2021
Budget and Savings Budgets Sums Past Transactions [Ignore - Operator Error] Google Sheets	3	144	November 18, 2023
How to account for budget items that are paid early? Google Sheets how-to , budgeting	5	646	March 5, 2020

Using Query function to sum transactions by category and month

Related Topics