Excel Function Reference — Sheets Academy

Math

ABS INT MOD ROUND ROUNDDOWN ROUNDUP SUM SUMPRODUCT

Statistical

AVERAGE COUNT COUNTA COUNTBLANK LARGE MAX MEDIAN MIN RANK SMALL

Logical

AND IF IFERROR IFNA IFS ISBLANK ISNUMBER NOT OR

Conditional counts and sums

AVERAGEIF AVERAGEIFS COUNTIF COUNTIFS MAXIFS MINIFS SUMIF SUMIFS

Lookup & Reference

CHOOSE HLOOKUP INDEX MATCH VLOOKUP XLOOKUP

Text

CONCAT FIND LEFT LEN LOWER MID PROPER RIGHT SEARCH SUBSTITUTE TEXTJOIN TRIM UPPER VALUE

Date & Time

DATE DATEDIF DAY EDATE EOMONTH MONTH NETWORKDAYS TODAY WEEKDAY WORKDAY YEAR

Dynamic arrays

FILTER SORT UNIQUE