Skip to content
Sheets Help

Tips, tutorials, and add-ons

  • Basics
  • Tutorials
  • Add-Ons

Tutorials

30/360, Actual/365, and Actual/360 Day Counts

July 15, 2023August 31, 2022 Adam Steinfurth

Learn the three day counting conventions that banks use to calculate interest.

Categories Tutorials Tags accounting, amortization, bank, day count, day counting, days360, interest

Create a Column of Random Numbers

June 12, 2024August 17, 2022 Adam Steinfurth

Learn several methods to generate a column of random numbers.

Categories Tutorials Tags arrayformula, COUNTA, int, rand, randarray, random

Summarize Unique Values In Google Sheets

November 1, 2024July 14, 2022 Adam Steinfurth

Learn how to list, count, and sum unique values from a table of data.

Categories Tutorials Tags COUNTIF, pivot table, query, SUMIF

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

Count With OR Logic in Google Sheets

October 30, 2025May 31, 2022 Adam Steinfurth

Count cells based on several conditions

Categories Tutorials Tags arrayformula, count, COUNTIF, or, query
Older posts
Newer posts
← Previous Page1 … Page15 Page16 Page17 … Page20 Next →
StaySorted moving a row automatically

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