Excel Formulas

Find the formula you need in our list of ready-to-use examples. Click a formula link for a full description. Related functions appear to the right and are also links.


FormulaRelated Functions
Count unique numeric values in a range
Count unique numeric values with criteria
Count unique text values in a range
Count unique text values with criteria
Count unique values in a range with COUNTIF
Count visible rows in a filtered list
Count visible rows only with criteria
COUNTIFS with multiple criteria and OR logic
Running count of occurrence in list
Summary count with COUNTIF


FormulaRelated Functions
Sum if date is greater than
Sum if ends with
Sum if equal to either x or y
Sum if greater than
Sum if less than
Sum if multiple criteria
Sum if cells not blank
Sum top n values
Sum visible rows in a filtered list
SUMIFS with multiple criteria and OR logic


FormulaRelated Functions
Average numbers
Average numbers ignore zero
Average top 3 scores
Weighted average

Min and Max

FormulaRelated Functions
Maximum if multiple criteria
Maximum value
Maximum value if
Minimum if multiple criteria
Minimum value
Minimum value if
nth largest value
nth largest value with criteria
nth smallest value
nth smallest value with criteria

Conditional Formatting

FormulaRelated Functions
Highlight entire rows
Highlight every other row
Highlight integers only
Highlight rows that contain specific text
Highlight rows with dates between
Highlight unique values
Highlight values between
Highlight values greater than
Highlight values not between X and Y
Highlight values that don't exist


FormulaRelated Functions
Position of max value in list
Related info for max value in range
Self-contained VLOOKUP
Two-way lookup with INDEX and MATCH
Two-way lookup with VLOOKUP
VLOOKUP with 2 lookup tables
VLOOKUP with calculated column index
VLOOKUP with numbers and text
VLOOKUP with two or more criteria
VLOOKUP without #N/A error


FormulaRelated Functions
If cell is this OR that
If cell is x or y and z
If else
If NOT this or that
If this AND that
Nested IF function example


Date And Time

Date Series