Excel Functions Reference

Looks up a value in the first column of a range and returns a value from a column to its right in the same row.

The modern replacement for VLOOKUP and HLOOKUP. Searches any array and returns a matching value from another array, in any direction.

Returns the value at a given row (and optional column) position within a range.

Returns the position of a value within a range, rather than the value itself.

Returns one value when a condition is true and another when it is false.

Returns a fallback value when a formula produces an error, otherwise the formula's result.

Adds the cells in a range that meet a single condition.

Adds cells that meet multiple conditions across several ranges.

Counts the cells in a range that meet a single condition.

Counts cells that meet multiple conditions across several ranges.

Adds all the numbers in one or more ranges.

Returns the arithmetic mean of the numbers in a range.

Averages the cells in a range that meet a condition.

Joins text from multiple cells or a range with a delimiter, optionally skipping blanks.

Joins text from several cells or literal strings into one value.

Extract a fixed number of characters from the start, end, or middle of a text value.

Removes leading, trailing, and repeated internal spaces from text.

Returns the difference between two dates in complete years, months, or days.

Return the current date (TODAY) or date and time (NOW); they update automatically.