Look up any Excel function — syntax, a real example, and when to use it.
Averages the numbers in a range that meet a single condition.
Averages numbers that meet multiple conditions across one or more ranges.
Counts how many cells in a range contain a number, ignoring text and blank cells.
Counts how many cells in a range contain anything at all — numbers, text, or dates — skipping only truly empty cells.
Counts how many cells in a range are empty.
Counts the number of cells in a range that meet a single condition.
Counts cells that meet multiple conditions across one or more ranges, all at once.
Returns the largest value in a set of numbers.
Returns the largest value in a range, but only among rows that meet one or more conditions.
Returns the smallest value in a set of numbers.
Returns the smallest value in a range, but only among rows that meet one or more conditions.
Adds the numbers in a range that meet a single condition.
Adds numbers that meet multiple conditions across one or more ranges.