All Functions in Excel (spreadsheet)

Formulas/Functions

SUM function – Sum multiple values in Excel

MAX – find the maximum value in a range

MIN – find the minimum value in a range

COUNT – Count numeric values in a range

COUNTA – Count numeric and textual values

AVERAGE – Calculate average of a range

IF function – check if a condition is met

COUNTIF – Count cells in range which meet a certain criteria

SUMIF – Sum range based on criteria

AVERAGEIF – Calculate the average of a range based on criteria

SUMIFS – Sum cells using multiple criteria

COUNTIFS – Count cells using multiple criteria

 MAXIFS – Find maximum value in a range based on criteria

MINIFS – Find minimum value in a range based on criteria

AND/OR – Check if multiple criteria are met (Works great when combined with an IF function!)

ISBLANK – Check if a cell is blank or not

VLOOKUP – lookup value and return corresponding value from a table

HLOOKUP – lookup value and return corresponding value from a table

LEFT, MID, RIGHT – Basic Text Functions

FIND – Find the position of a text within another text (Case-sensitive)

SEARCH – Find the position of a text within another text (Case-insensitive)

TRIM – Remove extra spaces from the text

LOWER, UPPER, PROPER – Convert text to lowercase, uppercase and proper case

VALUE – Convert data stored as text into values

Date functions

DAY, MONTH, YEAR – Extract day, month and year from a date in Excel

DATE – Create a date from individual values

COUNTA – Count numeric and textual values

AVERAGE – Calculate average of a range

AVERAGE – Calculate average of a range

IF function – check if a condition is met

COUNTIF – Count cells in range which meet a certain criteria

SUMIF – Sum range based on criteria

AVERAGEIF – Calculate the average of a range based on criteria

SUMIFS – Sum cells using multiple criteria

COUNTIFS – Count cells using multiple criteria

MAXIFS – Find maximum value in a range based on criteria

MINIFS – Find minimum value in a range based on criteria

AND/OR – Check if multiple criteria are met (Works great when combined with an IF function!)

ISBLANK – Check if a cell is blank or not

VLOOKUP – lookup value and return corresponding value from a table

HLOOKUP – lookup value and return corresponding value from a table

LEFT, MID, RIGHT – Basic Text Functions

FIND – Find the position of a text within another text (Case-sensitive)

SEARCH – Find the position of a text within another text (Case-insensitive)

TRIM – Remove extra spaces from the text

LOWER, UPPER, PROPER – Convert text to lowercase, uppercase and proper case

VALUE – Convert data stored as text into values

Date functions

DAY, MONTH, YEAR – Extract day, month and year from a date in Excel

DATE – Create a date from individual values

COUNT – Count numeric values in a range

COUNTA – Count numeric and textual values

AVERAGE – Calculate average of a range

IF function – check if a condition is met

COUNTIF – Count cells in range which meet a certain criteria

SUMIF – Sum range based on criteria

AVERAGEIF – Calculate the average of a range based on criteria

SUMIFS – Sum cells using multiple criteria

COUNTIFS – Count cells using multiple criteria

 MAXIFS – Find maximum value in a range based on criteria

MINIFS – Find minimum value in a range based on criteria

AND/OR – Check if multiple criteria are met (Works great when combined with an IF function!)

ISBLANK – Check if a cell is blank or not

VLOOKUP – lookup value and return corresponding value from a table

HLOOKUP – lookup value and return corresponding value from a table

LEFT, MID, RIGHT – Basic Text Functions