Spreadsheet functions are the building blocks of powerful formulas in Google Sheets and Excel. This hub collects clear, practical guides for the most commonly used spreadsheet functions, including conditional logic, text manipulation, date calculations, and function comparisons—so you can choose the right formula every time.
Conditional Counting and Summing Functions
These functions calculate totals or counts based on one or more conditions. They are essential for reports, dashboards, budgets, and data analysis.
Conditional Average Functions
Use these functions to calculate averages based on specific criteria, such as category, date range, or status.
Text Functions
Text functions help you extract, combine, or manipulate text values inside cells.
Date Functions
These functions help with date-based calculations such as billing cycles, expiration dates, and scheduling.
- EDATE and EOMONTH
Function Comparisons
These guides compare similar functions and explain which one to use in different situations.
Looking for more spreadsheet tutorials?
Browse our full collection of spreadsheet guides, tips, and walkthroughs.