A complete list of all Excel functions in alphabetical order.

Excel Formulas Cheat Sheet · Page 4 of 7 · Statistical Formulas · Formula · Structure · Explanation · SUMIF · = SUMIF(range, criteria, [sum_range])  · SUMIF will return at total based on one criteria ·  · Range - Required. The range of cells that you want evaluated by criteria.

December 29, 2025 - Learn how to add arithmetic, string, time series, and complex formulas in Microsoft Excel. ... Get your team access to the full DataCamp for business platform. Before diving into the details, here is a quick reference list of the top 15 formulas and functions every Excel user should know to improve efficiency and analysis.

7. IFERROR- You can always use the lovely IFERROR formula to handle errors in your formulas. 8. SMALL & LARGE- Used to find nth smallest value from a list and nth largest value from a list. 9. Basic Arithmetic Expressions- Most people jump in to Excel formulas without first learning various basic operators & expressions.

Lists all Excel functions by their category, such as Logical functions or Text functions.

November 4, 2025 - Adding numbers: If you want to add two or more numbers, you use a formula like =SUM(number1, number2). So, if you type =SUM(5, 3), Excel will show the answer 8. Finding the biggest number: If you have a list of numbers and want to know the biggest ...

Over 1000 working Excel formulas with detailed explanations, videos, and related links. Includes key functions like VLOOKUP, XLOOKUP, INDEX & MATCH, FILTER, RANK, ROUND, AVERAGE, COUNTIFS, SUMIFS, UNIQUE, SORT, TEXTSPLIT, and more.

Lets use the fill function to continue the formula, step by step: ... That is cool, right? The fill function continued the calculation that you used for Iva and was able to understand that you wanted to count the cells in the next rows as well. Now we have counted the Pokeballs for all three; Iva(6), Liam(12) and Adora(15). Let's see how many Pokeballs Iva, Liam and Adora have in total. The total is called SUM in Excel.

JavaScript is disabled in your browser · Please enable JavaScript to proceed · A required part of this site couldn’t load. This may be due to a browser extension, network issues, or browser settings. Please check your connection, disable any ad blockers, or try using a different browser

We cannot provide a description for this page right now

In the list range, select the range finder icon. ... Do the same for the criteria range. ... Excel’s traditional formulas do not work on filtered data since the function will be performed on both

Look up values horizontally in a list by using an approximate match · To do this task, you can use the VLOOKUP function, or a combination of the INDEX and MATCH functions. For more information, see VLOOKUP function. ... =INDEX(I want the return value from C2:C10, that will MATCH(Kale, which is somewhere in the B2:B10 array, where the return value is the first value corresponding to Kale)) The formula looks for the first value in C2:C10 that corresponds to Kale (in B7) and returns the value in C7 (100), which is the first value that matches Kale.

3 weeks ago - Discover Excel formulas list with examples: lookup, logical, text, date, and math functions. Learn when to use each and avoid common formula errors.

February 28, 2025 - Discover how to create a formula in Excel from text functions alone. See examples, definitions, and a list of text functions in Excel.

August 1, 2025 - Summary: Discover 20 essential Excel formulas designed to boost your productivity and data analysis skills. This guide covers everything from basic calculations like SUM and AVERAGE to powerful lookups like XLOOKUP and logical functions like IF. Master these to save time, reduce errors, and work more efficiently. In a world overflowing with data, Microsoft Excel remains a titan of data management and analysis. From organizing a simple shopping list to performing complex financial modeling, its power is undeniable.

November 6, 2025 - X Excel Formulas List · Frequently Asked Questions · This comprehensive guide will help you to master Excel formulas. Learn essential and advanced functions with examples to boost productivity, streamline calculations, and enhance data analysis in your spreadsheets.

July 14, 2022 - Example of how to use the Insert Function option in Excel: This option is for those who want to quickly delve into their favorite functions. To find this menu, navigate to the Formulas tab and select your preferred group. Click to show a sub-menu filled with a list of functions.

Over 350 built-in functions, with examples and videos. VLOOKUP, XLOOKUP, INDEX & MATCH, FILTER, RANK, ROUND, SUMPRODUCT, AVERAGE, COUNTIFS, SUMIFS, UNIQUE, SORT, TEXTSPLIT, SEQUENCE, FIND, SEARCH, DATE, and more.

February 16, 2026 - number1, [number2]: are the numbers or range (e.g., C5:C12) to evaluate. Apply this to find the highest value, such as the most expensive item in a list.

Here is a cheat sheet I found of 25 Basic Excel Formulas you need to know!