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

January 29, 2026June 26, 2024 Adam Steinfurth

Learns five situations where calculated fields improve your pivot tables.

Categories Tutorials Tags calculated field, pivot table

Count Amounts by Day of the Week in Google Sheets

October 30, 2025December 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

October 30, 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

December 1, 2025December 19, 2023 Adam Steinfurth

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

Categories Tutorials Tags day, day of the week, days, pivot table, query, sum, weekday

Sum Values Based on Another Cell’s Values in Google Sheets

October 24, 2025October 20, 2023 Adam Steinfurth

Learn how to sum amounts based on the values in other cells.

Categories Tutorials Tags pivot table, query, SUMIF, unique
Older posts
Page1 Page2 Next →

Keep your data sorted automatically

StaySorted moving a row automatically

Install StaySorted

Join over 30,000 users

  • Home
  • Subscriber Portal
  • Functions
  • About
  • Contact
© 2026 Sheets Help • Built with GeneratePress