Combine Monthly Google Sheets Tabs with QUERY and Verify the Totals
You can combine monthly tabs in one Google Sheets spreadsheet without repeatedly copying their rows into a report. This tutorial stacks three matching source ranges and runs QUERY over the combined input. It keeps one header, excludes rows without a date and updates when a new record is added to an included source tab.
Keep the source layout consistent
The demonstrated spreadsheet has January, February and March tabs. Each uses the same three columns in the same order: Date, Item, Amount. Row 1 contains the column labels, and records begin in row 2. Dates are real spreadsheet dates and amounts are numeric values.
Check those assumptions before writing the report formula. A date that only looks like a date can still be text. Applying a currency format to an amount stored as text does not make it numeric. Google’s QUERY documentation explains that a mixed-type column is interpreted according to its majority type, with other types treated as null. That can produce missing values even when the source cells look plausible.
Build the combined report
Create a tab named Report. Leave its output area empty and enter this formula in A1:
=QUERY(
{January!A1:C;February!A2:C;March!A2:C},
"select Col1, Col2, Col3 where Col1 is not null",
1
)This is the formula structure demonstrated in the video. It uses the comma-based function syntax of the example spreadsheet. Formula separators can differ with locale, so preserve the same range widths and vertical stacking when adapting the expression.
Understand each part before extending it
The braces build one input array. Semicolons stack January, February and March vertically. Every source contributes three columns; a range with a different width will not fit that array.
January!A1:C includes the first tab’s header. February and March start at row 2, excluding their repeated headers. The final 1 tells QUERY that the combined input contains one header row. This avoids relying on header detection.
The query selects all three combined columns, using Col1, Col2 and Col3 for the array’s columns. The condition where Col1 is not null keeps rows whose date column is populated. A record with an item and amount but no date will be excluded, so this report assumes that a date is required. Resolve incomplete records before treating the output as a complete transaction list.
Check the starting count and total
Format Report column A as dates and column C as currency. Put any checking formulas outside the report’s expanding A:C area, such as in E2 and E3:
=COUNT(A2:A)
=SUM(C2:C)The filmed sample initially contains seven records and an amount total of 109. COUNT works for its date column because those dates are numeric spreadsheet values. Exclude the header from both checks. If your results differ, inspect source types, missing dates, repeated headers and range boundaries before changing the query to hide the discrepancy.
Currency formatting controls presentation. It does not establish the intended unit or rounding rules. For a related example of checking monetary data explicitly, see our integer-cents and exact-total tutorial, which demonstrates that distinction in SQLite.
Prove that an added row is included
In the demonstration, a new Shipping record with amount 11 is added to March. The source references are open-ended, so that row falls within March!A2:C without editing the report formula. Returning to Report shows the Shipping record, a count of 8 and a total of 120.
Checking both the count and the total gives you two useful comparisons: one added record and an increase of eleven. Inspect the new row itself as well. A matching total alone can conceal missing or repeated records.
Know what does not update automatically
New rows inside an included tab are covered by its open-ended range. A newly created April tab is not: you must add its matching range to the stack. This example combines tabs within one spreadsheet; it does not import another spreadsheet.
Keep the report’s spill area clear and avoid using it for manual edits, which can block or conflict with the formula output. A live formula also reflects later source edits. If you need to reproduce an earlier report, retain the relevant source snapshot and a checked copy of the output; our backup and restore guide explains why preservation and recovery checks matter.
See the tutorials hub for other practical demonstrations. The primary references for this formula are Google’s QUERY function documentation and the Visualization Query Language reference.
James Kennedy is a writer and product researcher at Drives Hero with a background in IT administration and consulting. He has hands-on experience with storage, networking, and system performance, and regularly improves and optimizes his home networking setup.



