Functions

An overview of Excel functions, categorized for your convenience. Use the search bar below to quickly LOOKUP a function 😉

Search

Reference and lookup functions

• Vlookup
• Index
• Match
• Lookup
• Hlookup
• Indirect

Conditional functions

• If
• Sumif
• Sumifs
• Countif
• Countifs
• Iferror

Counting and summing

• Sum
• Count
• Counta
• Sumproduct

Functions on numbers

• Rand
• Round

Text functions

• Text
• Concatenate
• Len

Date and time

• Today
• Now
• Datedif

More functions

For more information on all of Excel’s built-in functions, you can check out the following links:

• Microsoft’s Excel support
• Get the newest Office (including Excel of course)