# 190+ Most Used Excel Functions List by Category

Get FREE Advanced Excel Exercises with Solutions!

In Excel, a function is a predefined formula that performs a specific calculation or task. Functions are built-in tools that allow you to automate calculations and manipulate data in various ways. They can be used to perform simple calculations like addition or subtraction, as well as more complex operations such as statistical analysis, financial calculations, and text manipulation.

Excel provides a wide range of functions to handle different types of data and perform various operations. Some common functions in Excel include SUM, AVERAGE, MAX, MIN, COUNT, IF, VLOOKUP, and CONCATENATE, among many others. Each function has a specific syntax (the way it is written) and requires specific arguments (input values) to perform the desired calculation.

By using functions in Excel, you can save time and effort by letting the software handle repetitive or complex calculations automatically. Functions can be entered directly into cells or used within formulas to perform calculations based on the values in other cells. They allow you to perform powerful data analysis and manipulate your data in meaningful ways.

For example, you have a dataset like the following. There are some clothing products in column A, and their corresponding prices & units are listed in the next two columns (B & C). Letâ€™s say you want to know the total sales for all products. Youâ€™ll have to multiply a productâ€™s price by its unit and then sum up the prices for all products, right?

But if you want to perform this manual calculation, itâ€™ll take some time and it matters most when you have to deal with a large amount of data. The SUMPRODUCT function in Excel will do this job for you in seconds. No matter how large the dataset is, the built-in function in Excel will save you crucial amounts of time. Letâ€™s have a look at how you can apply the SUMPRODUCT function to get the total sales for our given dataset in the screenshot below.

Here, the SUMPRODUCT function in cell B9 has taken 2 arguments- 1st one is the cell references (B2:B7) of the Price column & the 2nd one has come from the cell range (C2:C7) under the Unit header. And the output is just as what we expected- the total sales value, which weâ€™ve found in seconds! And this is what a built-in function is able to do for you by saving thousands of seconds or minutes from your regular work.

## 190++ Most Important & Useful Excel Functions by Category

There are around 450+ built-in functions in Microsoft Excel. Among them, weâ€™ll cover the most common & crucial functions that we have to use in our spreadsheets regularly. For your convenience, weâ€™ve categorized the list of all functions and linked them with individual articles. When you click on a function name, itâ€™ll open a new tab in your browser & redirect you to the particular function page. Youâ€™ll get all the necessary information & uses of that particular function in the article.

### 70 Most Popular & Common Excel Functions by Alphabetical Order

Before you dip into the main categories, you can have a glance at our selected list of the most common & popular Excel functions. Excel users around the world want to know about the basics of these functions in web searches and so we have added all those functions to a primary list. By learning the basics of all these functions, you can claim yourself an intermediate Excel user who is able to apply the necessary functions and combine them to build a useful formula for different purposes in the spreadsheets.

Function Name Objective
AND Checks whether all the arguments are TRUE, and returns TRUE if all arguments are TRUE.
AVERAGE Returns the average (arithmetic mean) of its arguments, which can be numbers or names, arrays, or references that contain numbers.
AVERAGEIF Finds average for the cells specified by a given condition or criterion.
AVERAGEIFS Returns the average of the cells of an array that satisfy one or more given criteria.
CHOOSE Chooses a value or action to perform from a list of values, based on an index number.
COLUMN Returns the column number of a cell reference.
COLUMNS Checks the number of columns in an array or reference and returns the number in digits.
CONCATENATE Joins two or more text values or numbers into one single text value.
CORREL Calculates the correlation coefficient of two cell ranges.
COUNT Counts the number of cells in a range that contains numbers.
COUNTA Counts the number of cells in a range that is not empty.
COUNTIF Counts the number of cells within a range that meets the given condition.
DATE Creates a date from numeric values in the arguments.
DATEDIF Determines how many days, months, or years there are between two dates.
DAY Returns the day of a date as a number between 1 and 31.
FILTER Filters some particular cells or values according to our requirements.
FIND Returns the starting position of a case-sensitive text string within another text string.
FLOOR Rounds a number down to the nearest multiple of significance.
FORECAST Predicts or calculates a future value with a linear trend.
FREQUENCY Returns how often numeric values occurred within the ranges you specify in a bin table of a set of data or dataset.
HLOOKUP Searches for a value in the top row of a table or array of values and returns the value in the same column from the specified row.
IF Checks whether a condition is met, and returns one value if TRUE, and another one if FALSE.
IFS Takes multiple conditions and values and returns the corresponding value to the first TRUE.
INDIRECT Stores data from the reference specified by a text string.
INT Rounds a decimal number down to the lowest integer portion.
IRR Calculates the internal rate of return.
ISNA Checks whether a value is #N/A, and returns TRUE or FALSE.
LARGE Returns the K-th largest value in a dataset where K must be a positive integer.
LEFT Finds the several characters of a text from left according to the number you provide.
LEN Reflects the length of text as a number.
LINEST Finds the least-squares method to compute the statistics for a straight line and returns an array describing that line.
LOOKUP Looks up a value in the one-row or one-column range.
MATCH Returns the lookup valueâ€™s relative position.
MAX Returns the largest value in a set of values. Ignores logical values and text.
MID Returns a specific number of characters from the middle of a string, given a specific starting position.
MIN Extracts the lowest or smallest value from a range of cells or cell references.
MOD Returns the remainder after a number is divided by a divisor.
MODE Returns the most frequently occurring, or repetitive, value in an array or a range of data.
NOT Always returns a logically opposite value.
OFFSET Starts off from a particular cell reference, moves to a specific number of rows down, then to a specific number of columns right, and then extracts out a section from the data set having a specific height and width.
OR Checks whether any arguments are TRUE, and returns TRUE or FALSE. Returns FALSE only if all arguments are FALSE.
PMT Calculates the payment for a loan based on a constant interest rate.
POWER Returns a number raised to a power.
PRODUCT Calculates the multiplication among numbers in Excel.
PROPER Converts a text string into the proper case; the first letter in each word to uppercase, and all other letters to lowercase.
PV Calculates the present value of a loan or investment.
RANK Returns the position of a given number in a given list of other numbers.
RATE Calculates the rate of interest.
REPLACE Replaces a part of a text string with a different text string.
REPT Repeats text a given number of times.
RIGHT Extract a specified number of characters from a given string from right to left.
ROUND Rounds a number based on the provided number of digits.
ROUNDUP Rounds a number up, away from zero.
ROW Returns the row number for a given cell reference.
SEARCH Returns the number of characters after finding a specific character or text string, reading from left to right.
SMALL Finds the k-th (generally what we know as nth) smallest value in a data set.
SORT Sorts a given range of cells according to a specific row or column in ascending or descending order.
SUM Adds all the numbers in each range of cells.
SUMIF Adds the cells specified by a given condition or criteria.
SUMIFS Add the cells given by specified conditions or criteria.
SUMPRODUCT Takes one or more arrays as an argument, multiplies the corresponding values of all the arrays, and then returns the sum of the products.
TEXT Converts a value to text in a specific number format.
TODAY Returns the current date formatted as a date.
TRANSPOSE Converts a vertical range of cells to a horizontal range or vice versa.
TREND Calculates the values of a given set of X and Y and returns additional Y-values by using the least square method based on a new set of X-values along with a linear trend line.
TRIM Removes extra spaces from a text string.
UNIQUE Returns a list of unique values in a range or in a list.
VALUE Converts a text string that represents a number to a number.
VLOOKUP Looks for a given value in the leftmost column of a given table and then returns a value in the same row from a specified column.
WEEKDAY Returns the day of the week for a given argument.

### Excel Database Functions

In Excel, database functions are a set of specialized functions that enable you to perform calculations and analysis on data stored in a database format. These functions are designed to work specifically with lists or tables of data that are structured in a consistent manner.

The database functions in Excel are useful when you need to extract or summarize data based on specific criteria, calculate statistics, or perform calculations on filtered data within a database. They can be used to perform tasks such as counting, summing, averaging, finding the maximum or minimum values, and more.

For example, we have a dataset like below. We need to know the minimum total price for laptop from the given data table. So, we can use the DMIN function with appropriate arguments to extract the minimum total price for a laptop easily.

Function Name Objective
DCOUNT Counts the cells that contain numbers in a field (column) of records in a list or database that fit the requirements that we define.
DCOUNTA Enumerates the number of non-empty cells in a given database based on criteria.
DMIN Determines the minimum value for a field/column based on user-specified criteria.
DPRODUCT Returns the product of a defined field from a database that matches specified criteria.
DSTDEV Calculates the standard deviation of a population based on a sample of data.
DSTDEVP Determines the standard deviation of a population based on the entire population by using the number or name of the heading in a column of the dataset that matches the conditions that are mentioned.
DSUM Calculates the total sum of a specific Field by matching specific Criteria from a given Range.
DVAR Obtains sample variance for matching records.

### Excel Date & Time Functions

The date and time functions allow you to work with dates and times in various ways. These functions enable you to perform calculations, and format date & time values within your spreadsheets. They are useful for tasks such as calculating durations, extracting specific components from dates or times, formatting date and time values, and more.

For example, we can use the NETWORKDAYS function to extract the total number of days between two given dates considering all listed holidays & weekends.

Function Name Objective
DATE Create a date from numeric values in the arguments.
DATEDIF Returns the difference of days, months or years between two dates.
DATEVALUE Converts a date in the form of text to a number that represents the date in Microsoft Excel date-time code.
DAY Returns the day of a date as a number between 1 and 31. This function is used for extracting a day number from a date.
DAYS Returns the number of days between two dates.
EDATE Provides a date according to the month number given in the argument.
EOMONTH Returns a string of numbers that represent the last day of the month before or after a specified number of months.
HOUR Returns the hour as a number from 0 (12:00 A.M.) to 23 (11:00 P.M.).
MINUTE Returns the number of minutes in a given time value.
MONTH Gets the month, as a number from 1 (January) to 12 (December).
NETWORKDAYS Returns the number of whole workdays between two dates.
NETWORKDAYS.INTL Returns the number of whole workdays between 2 dates with custom weekend parameters.
NOW Returns with the current date and time formatted as a date and time.
SECOND Extracts seconds from different types of time input.
TIME Returns the decimal number for an individual time.
TIMEVALUE Converts a text time to an Excel serial number for a time, a number from 0 (12:00:00 AM) to 0.999988426 (11:59:59 PM).
TODAY Returns the current date formatted as a date.
WEEKDAY Returns a number from 1 to 7 identifying the day of the week to a given date.
WEEKNUM Calculates the week number of a date.
WORKDAY Returns a date that is n working days in the future or the past.
WORKDAY.INTL Returns the serial number of the date before or after a specified number of weekdays with custom weekend parameters.
YEAR Calculates a year number from a date and it returns a 4-digit year of the corresponding date.
YEARFRAC Calculates the fraction of the year represented by the number of whole days between two dates.

### Excel Engineering Functions

The engineering functions simply perform engineering and scientific calculations, such as converting units, formatting binary values, working with complex numbers, and more. These functions can be used to solve specific engineering problems, perform conversions between different number systems, and handle complex calculations that are common in scientific and technical fields.

For example, we can use the CONVERT function for unit conversion as shown in the screenshot below.

Function Name Objective
COMPLEX Combines real and imaginary components together into complex values.
CONVERT Converts a number from one measurement system to another.
IMDIV Returns the result after dividing a complex number by another complex number.
IMAGINARY Extracts the imaginary coefficient from the corresponding complex number in Excel.
IMPRODUCT Returns the product of complex numbers, up to a maximum of 255 numbers.
IMSUM Returns the sum of two or multiple complex numbers in Excel.

### Excel Financial Functions

In Excel, financial functions are a set of built-in functions that ease your tasks with financial calculations and analysis. These functions are specifically designed for tasks related to finance, investments, loans, and other financial operations. They allow you to perform various calculations, such as determining loan payments, calculating interest, analyzing investment returns, and more. They are particularly useful for financial professionals, investors, and anyone involved in financial planning, analysis, or decision-making.

PV function is one of the most commonly used financial functions in Excel which we can use to determine the present value of a loan or investment under the given criteria.

Function Name Objective
DB Determines the depreciation cost of an asset in each period of time over its lifetime.
EFFECT Returns an effective annual interest rate based on the nominal interest rate and the number of compounding periods per year.
FV Calculates the future value of an investment.
IPMT Returns the interest payment for a given period for an investment, based on periodic, constant payments and a constant interest rate.
IRR Calculates the internal rate of return.
MIRR Considers both the finance and reinvest rates to calculate the modified internal rate of return.
NOMINAL Returns the nominal annual interest rate.
NPER Calculates the total number of periods over which the loan is fixed with a constant interest rate.
NPV Calculates the net present value (NPV) of an investment using a discount rate and a series of future cash flows.
PDURATION Calculates the number of periods required for an investment to reach a designated future value, at a constant interest rate.
PMT Returns the loan payments as a number.
PPMT Returns principal payments for a given period.
PRICE Calculates the breakeven price per \$100 face value of a bond or security.
PV Calculates the present value of a loan or investment.
RATE Calculates the rate of interest.
RRI Returns us an equivalent interest rate for the growth of an investment over a certain period.
SLN Returns the straight-line depreciation of an asset for one period.
XIRR Calculates the internal rate of return (IRR) for a series of cash flows.
YIELD Calculates the yield that pays interest on purchased bonds or security on a regular basis.

### Excel Information Functions

The information functions allow you to extract specific details about the data within cells and make decisions or perform calculations based on that information. These functions are useful for conditional formatting, data validation, or creating formulas that depend on specific cell characteristics.

For example, we can use the ISBLANK function to find the blank cells and later based on the outputs, we can show the conditional return values by combining it with another function.

Function Name Objective
CELL Returns information about a cell color, file name, contents, format, row, etc.
ISBLANK Evaluates if the cell is blank.
ISERROR Indicates any error value.
ISEVEN Determines if a number is even.
ISLOGICAL Checks if a cell contains any boolean or logical values.
ISNA Checks whether a value is #N/A, and returns TRUE or FALSE.
ISNUMBER Check whether a value is a number or not.
ISODD Determines if a number is odd.
ISTEXT Checks whether a value is text or not.
N Returns a value converted to a number.
SHEETS Counts the number of sheets.
TYPE Returns an integer number that represents the type of the selected data.

### Excel Logical Functions

In Excel, logical functions evaluate logical conditions and return true or false results. These functions are used to perform logical comparisons, make decisions, and test conditions within formulas or logical statements.

In the following example, we can find the use of the IF function. Here, based on the deadline of the payment, we can combine IF and DATE functions to know the payment status of the students.

Function Name Objective
AND Checks whether all the arguments are TRUE, and returns TRUE if all arguments are TRUE.
FALSE Returns the word FALSE to make remarks or compare with others.
IF Checks whether a condition is met, and returns one value if TRUE, and another one if FALSE.
IFERROR Generates a custom value as a result if there is any error from the formula.
IFNA Tackles the #N/A error.
IFS Takes multiple conditions and values and returns the corresponding value to the first TRUE.
NOT Returns a logically opposite value.
OR Checks whether any arguments are TRUE, and returns TRUE or FALSE. Returns FALSE only if all arguments are FALSE.
SWITCH Compares or evaluates a given expression which is a value against a list of values and returns a result corresponding to the first match found.
TRUE Returns the logical value TRUE based on a condition.
XOR Performs an exclusive OR function.

### Excel Lookup & Reference Functions

The reference and lookup functions are used to extract data from specific cells, ranges, or tables based on certain criteria or conditions. These functions allow you to search for values, match data across multiple ranges, and extract information from different parts of your spreadsheet.

For example, if we have a glance at the picture below, the HLOOKUP function here can be used to find the sales of a particular food item for a given date.

Function Name Objective
ADDRESS Creates a cell reference as text, given specified row and column numbers.
CHOOSE Chooses a value or action to perform from a list of values, based on an index number.
COLUMN Returns the column number of a cell reference.
COLUMNS Returns the count of columns in a given reference.
FILTER Filter some particular cells or values according to our requirements.
FORMULATEXT Returns the used formula as a string.
HLOOKUP Searches for a value in the top row of a table or array of values and returns the value in the same column from the specified row.
HYPERLINK Brings out a cutoff link that will open on a server, or make a move to other worksheets.
INDEX Returns a value or reference of the cell at the intersection of a particular row and column, in a given range.
INDIRECT Stores data from the reference specified by a text string.
LOOKUP Looks up a value in the one-row or one-column range.
MATCH Returns the lookup valueâ€™s relative position.
OFFSET Starts off from a particular cell reference, moves to a specific number of rows down, then to a specific number of columns right, and then extracts out a section from the data set having a specific height and width.
ROW Returns the row number for a given reference.
ROWS Returns the number of rows in a reference or array.
SORT Sorts a given range of cells according to a specific row or column in ascending or descending order.
TRANSPOSE Converts a vertical range of cells to a horizontal range or vice versa.
UNIQUE Returns a list or array of unique values.
VLOOKUP Looks for a given value in the leftmost column of a given table and then returns a value in the same row from a specified column.
XLOOKUP Searches a range or an array for a match and returns the corresponding item from a second range or array.

### Excel Math & Trig Functions

In Excel, the math and trig functions are a set of built-in functions that perform various mathematical and trigonometric calculations. These functions allow you to perform calculations involving numbers, angles, and geometric operations.

These math and trig functions enable you to perform a wide range of mathematical calculations, such as basic arithmetic operations, statistical analysis, rounding, exponentiation, and trigonometric calculations.

For example, the MOD function in Excel can be used to determine the remainder of a division between two valid numbers.

Function Name Objective
ABS Returns the absolute value of a number.
AGGREGATE Is used on different functions like AVERAGE, COUNT, MAX, MIN, SUM, PRODUCT, etc., with the option to ignore hidden rows and error values to get certain results.
CEILING Rounds up a number to its nearest upper integer or to the multiple of significance.
COMBIN Determines the total possible number of combinations for a given number of items without any repetition in Excel.
COS Determines the cosine of angles in Excel.
EVEN Rounds any number to a nearly even integer number.
EXP Calculates and returns the value of the constant e raised to the power of a given number.
FACT Returns the factorial of a number.
FLOOR Rounds a number down to the nearest multiple of significance.
INT Rounds a decimal value down to the lowest integer portion.
LN Calculates the natural logarithm of a number.
LOG Returns the logarithm of a number to the base you specify.
MMULT Multiplies two arrays of numbers and returns another array of numbers.
MOD Returns the remainder after a number is divided by a divisor.
ODD Rounds up or down a number to the nearest odd integer.
PI Returns the value of Pi, 3.14159265358979, accurate to 15 digits.
POWER Returns a number raised to a power.
PRODUCT Calculates the multiplication among numbers in Excel.
QUOTIENT Returns the integer part of a division without remainder.
RAND Returns a random number between 0 and 1.
RANDBETWEEN Returns a random integer between two given numbers, called bottom and top.
ROUND Rounds a number based on the provided number of digits.
ROUNDDOWN Rounds a number down, toward zero.
ROUNDUP Rounds a number up, away from zero.
SEQUENCE Creates a sequence of numeric values.
SIGN Returns a numberâ€™s sign as 0, +1, or -1.
SIN Determines the sine of angles in Excel.
SQRT Returns the square root of a number.
SUBTOTAL Offers 11 maths & trig functions to perform by inserting the corresponding argument.
SUM Adds all the numbers in each range of cells.
SUMIF Adds the cells specified by a given condition or criteria.
SUMIFS Adds the cells given by specified conditions or criteria.
SUMPRODUCT Takes one or more arrays as an argument, multiplies the corresponding values of all the arrays, and then returns the sum of the products.
TAN Determines the tangent of an angle.
TRUNC Truncates a number to an integer by removing the decimal, or fractional, part of the number.

### Excel Statistical Functions

The statistical functions allow you to perform statistical analysis and calculations on data sets. These functions enable you to calculate various statistical measures, such as averages, standard deviations, correlations, and more.

The AVERAGEIF function is one of the most used statistical functions in Excel which can be used to find an output based on given conditions.

Function Name Objective
AVERAGE Returns the average (arithmetic mean) of its arguments, which can be numbers or names, arrays, or references that contain numbers.
AVERAGEA Calculates the average of a group of values â€“ numbers, texts or boolean â€“ and returns the average (arithmetic mean) of the values.
AVERAGEIF Finds average for the cells specified by a given condition or criteria.
AVERAGEIFS Returns the average of the cells of an array that satisfy one or more given criteria.
CORREL Calculates the correlation coefficient of two cell ranges.
COUNT Counts the number of cells in a range that contains numbers.
COUNTA Counts the number of cells in a range that is not empty.
COUNTBLANK Counts the number of empty cells in a specified range of cells.
COUNTIF Counts the number of cells within a range that meets the given condition.
COUNTIFS Counts the number of cells in one or more given arrays that maintain one or more specific criteria.
FORECAST Calculates or predicts a future value based on existing value.
FREQUENCY Returns how often numeric values occurred within the ranges you specify in a bin table of a set of data or dataset.
GAMMA Finds the gamma function value of a number.
GROWTH Calculates predictive exponential growth for a given set of data.
INTERCEPT Determines the location where a regression line will intersect the y-axis.
LARGE Returns the K-th largest value in a dataset where K must be a positive integer.
LINEST Finds the least-squares method to compute the statistics for a straight line and returns an array describing that line.
MAX Returns the largest value in a given list of arguments.
MEDIAN Returns the median of a group of numbers.
MIN Extracts the lowest or smallest value from a range of cells or cell references.
MODE Returns the most frequently occurring, or repetitive, value in an array or a range of data.
PERCENTILE Calculates the kth percentile of the values in a particular data range.
PERMUT Returns the number of permutations for a chosen number of objects from a total number of objects without repetitions.
QUARTILE Finds the quartile (each of four equal groups) for a conveyed set of data.
RANK Returns the position of a given number in a given list of other numbers.
SKEW Calculates the skewness of a range of data in Excel.
SLOPE Returns the slope of the linear regression line through known yâ€™s and known xâ€™s data points.
SMALL Finds the k-th (generally what we know as nth) smallest value in a data set.
STDEV Estimates standard deviation.
VAR Returns the variance of a sample taken from population data.

### Excel Text Functions

In Excel, the text functions are a group of built-in functions that allow you to format text strings in various ways. These functions enable you to extract specific parts of a text, combine or concatenate multiple text strings, change the case of text, convert numbers to text, and more.

These text functions provide flexibility in working with text data in Excel. They can be used to clean data, extract information, create customized labels, and generate reports.

For example, we can combine FIND and MID functions to extract text or a word from the beginning of a cell.

Function Name Objective
CHAR Returns the character specified by the code number from the character set for your computer.
CLEAN Removes all of the non-printable characters from text.
CODE Returns a numeric code for the first character in a text string, in the character set used by your computer.
CONCATENATE Joins two or more text values or numbers into one single text value.
DOLLAR Converts a number into text in the form of a currency.
EXACT Compares two texts and then returns TRUE (in case the texts are exactly the same) or FALSE (in case the texts are exactly not the same).
FIND Returns the starting position of a case-sensitive text string within another text string.
FIXED Rounds a number to the fixed number of decimals, and formats the number in decimal format using a period and commas.
LEFT Returns a specified number of characters from the start of the provided text string.
LEN Returns the length of a given string.
LOWER Converts all the letters in a text string to lowercase.
MID Returns a specific number of characters from the middle of a string, given a specific starting position.
PROPER Capitalizes the first letter of each word in a given text string.
REPLACE Replaces a part of a text string with a different text string.
REPT Repeats text a given number of times.
RIGHT Extracts a specified number of characters from a given string from right to left.
SEARCH Returns the number of characters after finding a specific character or text string, reading from left to right.
SUBSTITUTE Replaces existing text with new text in a text string.
TEXT Converts a value to text in a specific number format.
TEXTJOIN Concatenates a list or range of text strings into a single string using a delimiter.
TRIM Removes the extra spaces from a text string.
UPPER Converts a text string to all uppercase letters.
VALUE Converts a text string that represents a number to a number.

## Concluding Words

In this article, we have covered 190+ functions with redirected posts. You can also have a look at our 102 Excel Cheatsheet Formulas where the functions have been explained elaborately. You can download the free pdf version of the functions cheatsheet too there.

## Excel Functions: Knowledge Hub

<< Go Back to Learn Excel

## What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.

Tags: