How to Use The AVERAGEIFS Function

How to Use The AVERAGEIFS Function feature image

The need to find the average of a range of numbers is fairly common. For instance, imagine you want to know the average grade in a selection of exam results, or the average order value for a customer. Thankfully, Excel has some built-in functions that can provide this information quickly. The AVERAGEIFS function is one of them, and it is the focus of this blog post. The AVERAGEIFS function allows you to select numerical values from a range of cells based on multiple criteria that you specify, in fact up to 127 criteria.

In this blog post, you will learn how to use the AVERAGEIFS function with multiple criteria, both text and numerical examples; how to use named ranges with the AVERAGEIFS function, and the reasons for and types of Excel error messages the AVERAGEIFS function might return.

Continue Reading →

How to Handle Excel Error Messages in Formulas

How to Handle Excel Error Messages Feature Image

Work with Excel formulas long enough, and you are going to bump into Excel error messages. They are annoying and can be time-consuming to deal with. However, there are things that you can do to handle the different types of Excel error messages you might receive. In fact, some of these error messages can be very important to the user of your spreadsheet.
In this blog post, we are going to look at the types of errors that can occur when writing formulas, and also look at some of the functions you can use to handle these error messages.

Continue Reading →

How to Use the VLOOKUP Function

The VLOOKUP function is one of the most commonly used and asked about Excel functions.

The VLOOKUP function enables you to perform a very useful method of finding data in a worksheet known as a lookup. In this post, you’ll learn the difference between VLOOKUP exact and approximate matching. You’ll see how to use the VLOOKUP function with named ranges, absolute and relative references, and wildcard characters; and you learn some of the errors that can occur.

Continue Reading →

How to Use The COUNTIF Function

How to Use the COUNTIF Function Feature Image

In this blog post, we’re going to look at how to use the COUNTIF function. The COUNTIF function counts the number of cells in a range that match a certain criterion. For example, imagine you have a range of cells that contains sales data, and you want to know how many times you have achieved a sales target. This is easy with the COUNTIF function; you simply count the number of cells equal to, or above, the sales target.

In this post you will learn how to use the COUNTIF function to count the number of cells that contain specific numbers, text strings, and dates. We will also look at how to use the COUNTIF function with different comparison operators and wildcard characters.

Continue Reading →

How to Use Excel Wildcard Characters in Formulas

How-to-Use-Excel-Wildcard-Characters-in-Formulas-Twitter

Excel has a number of characters referred to as wildcard characters that enable you to carry out partial matching on a text string. For example, imagine you want to search or count all the people in a list whose last name is Smith. You could use wildcard characters to search for names ending in Smith irrespective of their first name.

Wildcard characters can be used in formulas, conditional formatting, filtering, and Excels search and replace feature. In this post, I will show you how to use Excel wildcard characters in formulas.

Continue Reading →

Page 2 of 7