Brought to you by:

Hi Reader,

Welcome to the Google Sheets Tips newsletter #370, your Monday morning espresso, in spreadsheet form!

This is the last Google Sheets Tips email for 2025.

We're taking a break from publishing for the holidays and will return with Tip 371 on 5th January 2026.

Thank you so much for reading and replying to these emails. I love learning from all of you when you write back and share your own tips and tricks (and occasional corrections! 😉 ).

In the meantime, I wish you all a Happy Holidays! 🎅 🎄 🎁 ☃️

Brought to you by: Query Streams SQL to Google Sheets in Minutes—Zero Code Required Query Streams makes it effortless to bring live SQL data straight into Google Sheets with absolutely no coding required. Connect in minutes, run queries instantly, and refresh data automatically without dealing with VPNs, firewall rules, drivers, or technical setup. Query Streams works with SQL Server, PostgreSQL, MySQL, MariaDB, SQLite, and Access, with additional databases coming soon. It gives teams a simple, unified way to work with real-time data directly inside Sheets. Share queries securely, control access, and eliminate CSV exports or complex scripts. It’s the fastest, most reliable way for teams to use live database data in Google Sheets. Try Query Streams — Free Forever

➜ Sheets Tip #370: Upgrade your Tables with this quick trick

If you've been reading these emails or attended one of my recent webinars, you'll know that I'm a strong advocate of using Tables. They have many built-in benefits such as data validation, column types, named ranges, etc.

One of those benefits is the ability to add a footer to our Tables with a single click. And, if we set the column type to one of the numeric data types (e.g. Currency), the footer will automatically add a SUM function to our data.

Add a footer from the Table menu (next to the Table name):

In our Sheet, it looks like this:

This is great!

But, but, but... (There is always a but.)

If we apply any filters to our data, then that SUM total will be incorrect.

Consider this example, where we apply a filter to show only the vegetables:

The SUM function still shows the total value of all the items ($40.70) and not the total of only the vegetables ($12.10).

Hmm? That's a problem...

The solution is to switch the SUM function to a SUBTOTAL function, which only includes the visible rows in the aggregation calculation.

Delete the SUM function and type this one instead:

where the number 9 specifies a SUM calculation. Other options include 1 = Average, 4 = Max, 5 = Min (see here for a full list).

"Table1[Expense]" refers to the Expense column of Table1.

In our Sheet, the total now displays the correct value:

If you enjoyed this newsletter, please forward it to a friend who might enjoy it.

Have a great week!

Cheers,
Ben

P.S. AI auditioning for acting job​