How to Use AVERAGEIF with Multiple Ranges in Excel

In this tutorial, you will learn how to use AVERAGEIF with multiple ranges in Excel.

The average of integers in a range that satisfy given conditions is determined using the Excel AVERAGEIF function. For partial matching, AVERAGEIF criteria can also use wildcards (*,?) and logical operators (>,,>,=).

Once ready, we’ll get started by utilizing real-world examples to show you how to use AVERAGEIF with multiple ranges in Excel.

Use AVERAGEIF with Multiple Ranges in Excel

Before we begin we will need a group of data to use AVERAGEIF with multiple ranges in Excel.

Step 1

First, you need to have a clean and tidy group of data to work with.

Step 2

In this example, we want to average the total items for only ‘Shirt’. To do so, we can insert the following formula =(SUM(SUMIF(A2:A13,G1,B2:B13),SUMIF(D2:D13,G1,E2:E13))/SUM(COUNTIF(A2:A13,G1),COUNTIF(D2:D13,G1))).

Step 3

Once we are done, you will be able to use AVERAGEIF with multiple ranges in Excel.