Formula Library
Excel & Google Sheets Formulas
Browse 361 practical formulas by category, search by name, or scroll A to Z.
361 formulas • Excel and Google Sheets • all on one page
0 formulas
Average
Calculate conditional and weighted and trimmed averages
0 formulas
Conditional Formatting
Highlight cells and rows based on condition-based rules
12 formulas
Count
Count cells based on values and conditions and text patterns
0 formulas
Data Validation
Control and restrict what users can enter in a cell
2 formulas
Date and Time
Calculate ages and durations and deadlines and working days
0 formulas
Dynamic Array
Filter and sort and generate lists that spill into multiple cells
0 formulas
Error Handling
Catch and replace errors with clean and readable fallback values
1 formula
Financial
Calculate loan repayments and interest and investments and depreciation
0 formulas
Grouping
Group and summarize data by category and month and custom criteria
3 formulas
If and Logic
Build conditional logic and return results based on multiple rules
4 formulas
Lookup
Find and return matching values from tables and data ranges
0 formulas
Math
Handle rounding and remainders and percentages and numeric operations
0 formulas
Miscellaneous
Useful formulas that solve specific problems outside other categories
1 formula
Percentage
Calculate percentage of total and percentage change and discounts
0 formulas
Range
Build dynamic and expanding ranges using indirect references
0 formulas
Rank and Sort
Rank values and find top results and sort lists dynamically
0 formulas
Round
Round numbers up or down to decimals or to the nearest multiple
2 formulas
Sum
Add up values based on one or more conditions or date ranges
1 formula
Text
Extract and combine and split and clean text from cells
0 formulas
Workbook and Reference
Pull data dynamically from other sheets and workbooks
Quick Formula Index
Type a formula name to search, or jump to a letter.
C
Date And Time
X
G
Calculate Age from Birthday in Excel and Google Sheets
Calculating age sounds like it should be simple — just subtract the birth date from today.…
→ View formula
Text
X
G
Combine First and Last Name in Excel and Google Sheets
Combining first and last names is one of those tasks that looks trivial until you actually…
→ View formula
Count
X
G
Count Blank Cells in Excel and Google Sheets
Counting blank cells is one of those checks I run on almost every dataset I open.…
→ View formula
Count
X
G
Count Cells Between Two Numbers in Excel and Google Sheets
Counting values that fall within a range — a score between 70 and 89, an amount…
→ View formula
Count
X
G
Count Cells Containing Specific Text in Excel and Google Sheets
Counting how many cells in a range contain a specific word somewhere in the text —…
→ View formula
Count
X
G
Count Cells Containing Text in Excel and Google Sheets
Counting how many cells in a column contain text — as opposed to numbers, blanks, dates,…
→ View formula
Count
X
G
Count Cells Equal to a Value in Excel and Google Sheets
Counting how many times a specific value appears in a column is one of those everyday…
→ View formula
Count
X
G
Count Cells Greater Than a Value in Excel and Google Sheets
Counting the number of values above a threshold is one of the most common analytical questions…
→ View formula
Count
X
G
Count Cells Less Than a Value in Excel and Google Sheets
Counting values below a threshold is the mirror image of counting values above one, and it…
→ View formula
Count
X
G
Count Cells Not Equal to a Value in Excel and Google Sheets
Counting cells that do not equal a specific value comes up more often than you might…
→ View formula
Count
X
G
Count Cells with Partial Text Wildcard in Excel and Google Sheets
Counting cells that match a partial text pattern — starts with a prefix, ends with a…
→ View formula
Count
X
G
Count Non-Blank Cells in Excel and Google Sheets
Counting how many cells in a range actually have something in them is one of the…
→ View formula
Count
X
G
Count Unique Values in Excel and Google Sheets
Counting unique values is a question I get asked constantly — how many distinct customers placed…
→ View formula
Count
X
G
COUNTIFS with Multiple Criteria in Excel and Google Sheets
COUNTIFS is the upgrade from COUNTIF that lets you count rows matching two or more conditions…
→ View formula
D
I
If And Logic
X
G
IF Function Basic Example in Excel and Google Sheets
If I had to pick one formula that changed how I use spreadsheets, it would be…
→ View formula
If And Logic
X
G
IF with AND — Test Multiple Conditions in Excel and Google Sheets
Combining IF with AND is one of the most powerful and frequently used formula patterns in…
→ View formula
Lookup
X
G
INDEX MATCH Basic Example in Excel and Google Sheets
INDEX MATCH is the lookup combination that power users swear by. While VLOOKUP is simpler to…
→ View formula
M
N
P
S
Sum
X
G
Sum with Multiple Conditions using SUMIFS in Excel and Google Sheets
SUMIFS is the multi-condition version of SUMIF and one of the most useful functions in any…
→ View formula
Sum
X
G
SUMIF with One Condition in Excel and Google Sheets
SUMIF was the first formula that made me feel like I actually understood Excel. Before it,…
→ View formula
V
Lookup
X
G
VLOOKUP Basic Example in Excel and Google Sheets
VLOOKUP is the lookup formula most people learn first, and for good reason — it solves…
→ View formula
Lookup
X
G
VLOOKUP with IFERROR in Excel and Google Sheets
VLOOKUP with IFERROR is one of the first formula combinations I teach anyone who uses lookups…
→ View formula
X