You use the SUMIF function to sum the values in a range that meet criteria that you specify. For example, suppose that in a column that contains numbers, you want to sum only the values that are larger than 5. You can use the following formula: =SUMIF(B2:B25,”>5″) This video is part of a training course called Add numbers in…

Excel provides you different ways to calculate percentages. For example, you can use Excel to calculate the percentage of correct answers on a test, discount prices using various percent assumptions, or percent change between two values. Calculating a percentage in Excel is an easy two-step process. First, you format the cell to indicate the value is a…

The IF function is one of the most used functions in Excel. This page contains many easy to follow IF examples. Simple If Examples The IF function checks whether a condition is met, and returns one value if true and another value if false. 1a. For example, take a look at the IF function in cell B2 below….

The V LOOKUP function is one of the most popular functions in Excel. This page contains many easy to follow V LOOKUP examples. VLOOKUP Formula VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup]) To translate this to simple English, the formula is saying, “Look for this piece of information, in the following area, and give me some corresponding data from another column”….

The powerful COUNT function in Excel counts cells based on one criteria. This page contains many easy to follow COUNT examples. Countif with Numeric Criteria You can use the COUNTIF function in Excel to count cells that contain a specific value, count cells that are greater than or equal to a value, etc. 1. For example, the COUNTIF function…

n one of our previous articles, we unveiled the power of compound interest and how to calculate it in Excel. Today, we’ll take a step further and explore different ways to compute Compound Annual Growth Rate (CAGR). In simple terms, CAGR measures the return on an investment over a certain period of time. Strictly speaking, it’s not…

The SUM IF function is categorized under Excel Math and Trigonometry functions. It will sum up cells that meet the given criteria. The criteria are based on dates, numbers, and text. It supports logical operators such as (>, <, <>, =) and also wildcards (*, ?). This guide to the SUMIF Excel function will show you…

Use the IFERROR function in Excel to return an alternative result, such as text, when a formula evaluates to an error. You can use the IFERROR function to trap and handle errors in a formula. IFERROR returns a value you specify if a formula evaluates to an error; otherwise, it returns the result of the formula. Syntax IFERROR(value, value_if_error)…

To calculate the sum of the products of corresponding numbers in one or more ranges, use Excel’s powerful SUMPRODUCT function. Basic Use 1. For example, the SUMPRODUCT function below calculates the total amount spent. Explanation: the SUMPRODUCT function performs this calculation: (2 * 1000) + (4 * 250) + (4 * 100) + (2 * 50)…

This Excel tutorial explains how to use the Excel HLOOKUP function with syntax and examples. How to handle errors such as #N/A and retrieve the correct results is also discussed. Description The Microsoft Excel HLOOKUP function performs a horizontal lookup by searching for a value in the top row of the table and returning the value in the same…

The AVERAGE function in Excel calculates the average (arithmetic mean) of a group of numbers. The AVERAGE function ignores logical values, empty cells and cells that contain text. Average Instead of the AVERAGE function, use the SUM and the COUNT function. 1. For example, the AVERAGE function below calculates the average of the numbers in cells A1 through A3. 2. The…

Learn how to use all 300+ Excel formulas and functions including worksheet functions entered in the formula bar and VBA functions used in Macros. Worksheet formulas are built-in functions that are entered as part of a formula in a cell. These are the most basic functions used when learning Excel. VBA functions are built-in functions that are…

Use the INDIRECT function in Excel to convert a text string into a valid reference. You can use the & operator to create text strings. Description Returns the reference specified by a text string. References are immediately evaluated to display their contents. Use INDIRECT when you want to change the reference to a cell within a formula without changing…

The VLOOKUP function is one of the most popular functions in Excel. This page contains many easy to follow VLOOKUP examples. Exact Match Most of the time you are looking for an exact match when you use the VLOOKUP function in Excel. Let’s take a look at the arguments of the VLOOKUP function. 1. The VLOOKUP function below…