Changing the Calculation of Values

Pivot Tables in Google Sheets

Frank Sumanski

Founder, SpreadsheetAllstars.com

Other calculation options for values

• Counting Calculations
  • COUNT: Counts numerical values only
  • COUNTA: Counts all non-blank values
  • COUNTUNIQUE: Counts all non-blank values (excluding duplicates)
• Ranking Calculations
  • AVERAGE, MAX, MIN, MEDIAN
• Mathematical Calculations
  • PRODUCT
• Statistical Calculations
  • STANDARD DEVIATION, VARIANCE

Let's practice!

Pivot Tables in Google Sheets