Search results
Lists all Excel functions by their category, such as Logical functions or Text functions.
Detect errors in formulas. A complete list of all Excel functions in alphabetical order.
Excel Functions List with free downloadable examples. Learn the syntax for 200+ of the most commonly used Excel and Google Sheets functions.
Over 350 built-in functions, with examples and videos. VLOOKUP, XLOOKUP, INDEX & MATCH, FILTER, RANK, SUMPRODUCT, AVERAGE, COUNTIFS, SUMIFS, UNIQUE, SORT, TEXTSPLIT, SEQUENCE, FIND, DATE, and more. See also 500 Formulas, 101 Functions, and New Excel Functions.
This page provides a complete Excel Functions list, grouped by category. Each of the function links will take you to a dedicated page, where you will find a description of the function, with examples of use and details of common errors.
Logically compare values with the IF function. IF function - nested formulas and avoiding pitfalls. IFS function. Count cells using a single criteria, use the COUNTIF function. Count cells using multiple criteria, use the COUNTIFS function. Count unique values among duplicates. Add values that meet a single criteria with SUMIF function
30 sie 2024 · 1. Basic Math Functions. 2. Logical Functions. 3. Text Functions. 4. Lookup and Reference Functions. Read more about them here.