Excel Function Reference

Searchable quick reference for 60+ Excel functions

Written by toolforge.websiteLast reviewed 23 August 2026How we build and check these tools

231 functions found

Excel Function Reference: key facts

What it does: Searchable quick reference for 60+ Excel functions
Category: Workplace Tools
Cost: Free, with no account, sign-up, or install.
Your data: Runs entirely in your browser — the files and text you enter are never uploaded to a server.
Last reviewed: 23 August 2026. Report an incorrect result.

What the Excel Function Reference does

Excel has hundreds of worksheet functions, but most spreadsheets rely on a core set of perhaps sixty: the lookup functions (VLOOKUP, INDEX, MATCH, XLOOKUP), the conditional aggregations (SUMIF, SUMIFS, COUNTIF, AVERAGEIF), the logical tests (IF, IFS, AND, OR, IFERROR), the text utilities (LEFT, MID, RIGHT, TRIM, TEXT, LEN), the date calculations (DATE, TODAY, EDATE, NETWORKDAYS), and the statistical functions (SUM, AVERAGE, MIN, MAX, STDEV). Knowing these sixty well covers the overwhelming majority of real-world spreadsheet work.

This reference covers 231 functions with a concise syntax signature and a description of every argument. Ten category filters narrow the list — Lookup & Reference, Logical, Text, Math & Trig, Date & Time, Financial, Statistical, Information, the Dynamic Array family, and the functions that exist only in Google Sheets. Each entry answers the "what does this argument actually do?" question quickly, which is the question you usually have mid-formula when you cannot stop to read full documentation. Everything is displayed instantly in your browser with no network requests.

Using the Excel Function Reference, step by step

Use the search box to type any function name or keyword. Results filter in real time as you type.
Click a category filter to narrow the list to one group, including Dynamic Array for the spilling functions and Google Sheets for the ones Excel does not have.
Click any function card to see its full syntax signature and a description of each argument, including which arguments are optional.
Use the search and category filter together to zero in on a function type — for example, search "if" within Logical to see IF, IFS, IFERROR, IFNA, and SWITCH side by side.

What makes this one worth using

Category filtering: browse every function in one domain at once, which is what you want when you know the kind of function you need but not its name. Dynamic Array and Google Sheets are separate categories so the modern and platform-specific functions are easy to find.
Instant search: the search field filters by function name in real time, so typing "sum" immediately shows SUMIF, SUMIFS, SUMPRODUCT, and SUM — no page reload or button press required.
Full signature for every function: each entry shows the exact argument order with the optional arguments marked, so you can tell at a glance where a comma belongs and which arguments you are allowed to leave out.
Shares its database with the Formula Explainer: both tools read the same 231 entries, so a function described here is described identically there. The explainer links straight back to the matching entry for any function it finds in your formula.

Frequently Asked Questions

What is the difference between VLOOKUP and XLOOKUP?

VLOOKUP searches the first column of a range and returns a value from a column to its right. XLOOKUP, introduced in 2019, is more flexible: the lookup array and return array are specified independently (so you can look up from any column and return from any column, including columns to the left), it defaults to exact match, and it has a built-in not-found value argument instead of requiring IFERROR wrapping. XLOOKUP is the modern replacement for VLOOKUP in newer Excel and Google Sheets versions.

When should I use SUMIFS instead of SUMIF?

Use SUMIFS whenever you have more than one condition. SUMIF accepts only one criterion range and one criterion; SUMIFS accepts up to 127 condition pairs. The syntax is also slightly different: in SUMIF the sum range comes first, but in SUMIFS the sum range also comes first and conditions follow in criterion_range, criterion pairs. SUMIFS works identically to SUMIF when only one condition is provided, so you can always use SUMIFS.

What does IFERROR do?

IFERROR(value, value_if_error) evaluates the first argument and, if it produces any error value (#N/A, #VALUE!, #REF!, #DIV/0!, #NUM!, #NAME?, or #NULL!), returns the second argument instead. It is most commonly used to suppress #N/A from VLOOKUP or MATCH when a lookup value is not found — for example, =IFERROR(VLOOKUP(A2,Table,2,0),"Not found") returns "Not found" instead of #N/A.