*PROVIDING ACCURATE, RELIABLE AND STRAIGHT TO THE POINT KNOWLEDGE ABOUT DIFFERENT IT TOOLS EXPLAINED WITH PRACTICAL EXAMPLES*

#### CONTENTS

# EXCEL FUNCTIONS-AVERAGEIF

## INTRODUCTION

*AVERAGEIF FUNCTIONS comes under the STATISTICAL FUNCTION group of Excel.*

*If we remember the SUMIF function, AVERAGEIF function is almost similar to that function.*

*AVERAGEIF FUNCTION gives an option to find out the option of the data if a particular given criteria or condition is fulfilled. It gives us the control over filtering the data in the function itself and save our time.*

* *

*e.g. *

*Suppose we need to find out the average age of the persons present in a party but only those persons whose age is >50.*

*This can be done directly using this function. Later in this article we’ll see this using an example.*

* *

## PURPOSE OF AVERAGEIF FUNCTION IN EXCEL

**AVERAGEIF FUNCTION finds out the average of the terms from the data which satisfies the given condition.**

## PREREQUISITES TO LEARN averageif

THERE ARE A FEW PREREQUISITES WHICH WILL ENABLE YOU TO UNDERSTAND THIS FUNCTION IN A BETTER WAY.

- Basic understanding of how to use a formula or function.
- Basic understanding of rows and columns in Excel.
- Some information about the statistical terms is an advantage for the use of such formulas.
- Of course, Excel software.

## SYNTAX: AVERAGEIF FUNCTION

**The Syntax for the function is**

**=AVERAGEIF**(RANGE , CRITERIA , AVERAGE RANGE)

**RANGE**RANGE IS THE FULL DATA SET TO BE ANALYZED

**CRITERIA**CONDITION ON WHICH THE DATA WILL BE SELECTED FOR THE OPERATION

**AVERAGE_RANGE**THE FINAL SET OF DATA ON WHICH OPERATION WILL BE DONE

**=AVERAGEIF**(RANGE , CRITERIA )

**RANGE**RANGE IS THE FULL DATA SET TO BE ANALYZED

**CRITERIA**CONDITION ON WHICH THE DATA WILL BE SELECTED FOR THE OPERATION

***IN SYNTAX 2, THE RANGE WILL ACT IN THE PLACE OF AVERAGE RANGE TOO. I.E. THE CHECK WILL BE PERFORMED ON THE RANGE AND OUTPUT WILL BE CALCULATED ON THE RANGE ITSELF ONLY.**

## EXAMPLE 1:AVERAGEIF FUNCTION IN EXCEL

### DATA SAMPLE

*THINK OF A SCENARIO.*

*THERE ARE FIVE PEOPLE. EACH EARNING BETWEEN $1000 TO $6000.*

*We need to find the average of income of people who earn more than $3000.*

*This scenario can be solved by manually separating the persons who have income more than $3000 and after that*

*calculating average on them or we can try AVERAGEIF function.*

* *

### STEPS TO USE AVERAGEIF FUNCTION (TWO ARGUMENTS)

## EXAMPLE 2:AVERAGEIF FUNCTION IN EXCEL

### STEPS TO USE AVERAGEIF FUNCTION (THREE ARGUMENTS)

CASE 2:

OTHER WAYS TO REACH THIS ARTICLE

## WHAT IS EXCEL, HOW EXCEL WORKS, WRITE FORMULA IN EXCEL, EXAMPLE OF USING FORMULA IN EXCEL, ANIMATED EXAMLPE OF USING FORMULA IN EXCEL

YOU MAY LIKE

- HOW TO TROUBLESHOOT A FORMULA IN EXCEL?
- USE OF FONTS, FONT SIZE, INDENTATION, TEXT TO THE RIGHT, TEXT TO THE LEFT, TEXT IN THE MIDDLE ETC.
- how to insert table in excel?
- FOR MORE ARTICLES, CLICK EXCEL OR TYPE IN SEARCH BELOW.