Skip to content
Sheets Help

Tips, tutorials, and add-ons

  • Basics
  • Tutorials
  • Add-Ons

pivot table

5 Reasons to Use Calculated Fields in Google Sheets Pivot Tables

October 25, 2024June 26, 2024 Adam Steinfurth

Learns five situations where calculated fields improve your pivot tables.

Categories Tutorials Tags calculated field, pivot table

Multi-Sheet Pivot Tables in Google Sheets | No Formulas

May 19, 2024January 4, 2024 Adam Steinfurth

Learn how to create a pivot table from data spread over multiple sheets.

Categories Tutorials Tags omnipivot, pivot table

Count Amounts by Day of the Week in Google Sheets

July 2, 2024December 24, 2023 Adam Steinfurth

Learn how to count transactions by day of the week and return a table with the day names and their corresponding counts.

Categories Tutorials Tags count, pivot table, query

Average Amounts for Each Day of the Week in Google Sheets

June 27, 2025December 23, 2023 Adam Steinfurth

Learn two methods to average amounts by day of the week.

Categories Tutorials Tags average, pivot table, query

Sum Amounts for Each Day of the Week in Google Sheets

May 12, 2024December 19, 2023 Adam Steinfurth

Learn two techniques to sum values by day of the week.

Categories Tutorials Tags day of the week, pivot table, query, sum, weekday
Older posts
Page1 Page2 Next →
OmniPivot Merging Tables

Get the Google Sheets Add-On
  • Home
  • Subscriber Portal
  • Functions
  • About
  • Contact
© 2025 Sheets Help • Built with GeneratePress