Search results
- SUM. This is the first function in Excel that most new users need. As the name implies, the SUM function adds up all the values in a specified group of cells or range.
- COUNT. Next up is the COUNT function. It returns the number of cells containing numeric values within the input range. Syntax: =COUNT(value1, [value2], …)
- AVERAGE. The average of a list of numbers is just the total divided by how many numbers there are in that list. This is easy enough to calculate the quiz scores.
- IF. The IF function is a very popular function in Excel and it is actually quite easy to learn. Syntax: =IF(logical_test, value_if_true, [value_if_false])
- Overview
- Compatibility functions
- User defined functions that are installed with add-ins
- Web functions
- Need more help?
- See Also
Worksheet functions are categorized by their functionality. Click a category to browse its functions. Or press Ctrl+F to find a function by typing the first few letters or a descriptive word. To get detailed information about a function, click its name in the first column.
In Excel 2010 or later, these functions were replaced with new functions that provide improved accuracy and have names that better reflect their usage. You can still use them for compatibility with earlier versions of Excel, but if backward compatibility isn't required, you should start using the new functions instead. For more information about the new functions, see Statistical functions (reference) and Math and trigonometry functions (reference) .
If you're using Excel 2007, you'll find these functions in the Statistical or Math & Trig categories on the Formulas tab.
If add-ins that you install contain functions, these add-in or automation functions will be available in the User Defined category in the Insert Function dialog box.
User-defined functions (UDFs) are not available in Excel for the web.
Web functions are not available in Excel for the web.
Version markers indicate the version of Excel a function was introduced. These functions aren't available in earlier versions.
You can always ask an expert in the Excel Tech Community or get support in Communities.
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.
- Svetlana Cheusheva
- SUM. The first Excel function you should be familiar with is the one that performs the basic arithmetic operation of addition: SUM(number1, [number2], …)
- AVERAGE. The Excel AVERAGE function does exactly what its name suggests, i.e. finds an average, or arithmetic mean, of numbers. Its syntax is similar to SUM's
- MAX & MIN. The MAX and MIN formulas in Excel get the largest and smallest value in a set of numbers, respectively. For our sample data set, the formulas will be as simple as
- COUNT & COUNTA. If you are curious to know how many cells in a given range contain numeric values (numbers or dates), don't waste your time counting them by hand.
Mar 21, 2023 · Excel functions list with formula examples that explain the use of text functions, math, logical and statistical functions, date and time functions, and more.
- Svetlana Cheusheva
Below is a brief overview of about 100 important Excel functions you should know, with links to detailed examples. We also have a large list of example formulas, a more complete list of Excel functions, and video training. If you are new to Excel formulas, see this introduction.
People also ask
What are the different types of Excel functions?
What are Excel functions?
What do we call a formula and a function in Excel?
How many functions are in Excel?
What are Excel operators?
What are the basic math functions in Excel?
Important: The calculated results of formulas and some Excel worksheet functions may differ slightly between a Windows PC using x86 or x86-64 architecture and a Windows RT PC using ARM architecture. Learn more about the differences .
Amazon offers products from hundreds of top brands at great prices. Shop low prices on holiday essentials. Free shipping, exclusive discounts, and more.
