Skip to content
Sheets Help

Tips, tutorials, and add-ons

  • Basics
  • Tutorials
  • Let’s Talk 💬
  • Add-Ons

unique

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

September 9, 2024October 20, 2023 Adam Steinfurth

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

Categories Tutorials Tags pivot table, query, SUMIF, unique

Conditionally Count Unique Values in Google Sheets

August 8, 2024December 19, 2022 Adam Steinfurth

Three techniques to count unique values based on specified criteria.

Categories Tutorials Tags array, count, countuniqueifs, function, query, unique

COUNTUNIQUEIFS Function – Google Sheets

September 21, 2023December 14, 2022 Adam Steinfurth

Count unique values based on multiple criteria.

Categories Math Tags conditional count, count, COUNTIF, countuniqueifs, IF, unique

UNIQUE Function – Google Sheets

December 3, 2022 Adam Steinfurth

Remove duplicate lines from a table of data

Categories Filter Tags array, duplicates, filter, unique

Count Unique Values Regardless of Capitalization – Google Sheets

May 11, 2023June 29, 2022 Adam Steinfurth

Count unique values in a spreadsheet while ignoring capitalization.

Categories Tutorials Tags arrayformula, case insensitive, case sensitive, count, proper, unique
Older posts
Page1 Page2 Next →
StaySorted moving a row automatically

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