Adds together a range of numbers., =SUM(range), Finds the mean average of a range of numbers., =AVERAGE(range), Tests a condition and returns one value if true and another if false., =IF(condition, value_if_true, value_if_false), Looks for a value in the first column of a table and returns information from another column in the same row., =VLOOKUP(lookup_value, table_range, column_number, exact/approx), Finds the largest number in a range., =MAX(range), Finds the smallest number in a range., =MIN(range), Counts how many cells in a range contain numbers., =COUNT(range), Counts how many cells in a range are not empty., =COUNTA(range), Counts how many cells in a range meet a condition., =COUNTIF(range, condition), Counts the number of characters in a cell, including letters, numbers, spaces and punctuation., =LEN(cell), Multiplies numbers together., =PRODUCT(range)

Excel Functions

by
Print
Embed

Leaderboard

We are currently working on improving the Leaderboard functionality. Please help us by offering your feedback.

Give Feedback

Visual style

Options

We are currently working on improving the Activity Settings. Please help us by offering your feedback.

Give Feedback

Switch template

Continue editing: ?