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.
Table of Contents
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.
