AVERAGEIF Function in excel With Example
AVERAGEIF
calculates the average of the numbers in a range that meet on single condition.
The
AVERAGEIF Function is an Excel Statistical function, which calculates the
average of a given range of cells.
Syntax
AVERAGEIF(
range, criteria, [average_range] )
Arguments
Range : The range of cells that you want to apply the
criteria against.
Criteria : The criteria used to determine
which cells to average.
average_range :
It is the cells to average.
For Example
below as shown in image here I want to calculate the average amount of these
transaction.
1 Online Average
Amount
2 Cash
Average Amount
3 Debit
Card Average Amount
4 Debit Average
Amount
5 Credit Average
Amount
1 Online Average Amount
Here
calculated average amount in cell G2 which is highlighted by yellow color.
Function : =AVERAGEIF(B2:B13,F2,D2:D13)
2 Cash Average Amount
Here
calculated average amount in cell G3 which is highlighted by yellow color.
Function : =AVERAGEIF(B2:B13,F3,D2:D13)
3 Debit Card Average Amount
Here
calculated average amount in cell G4 which is highlighted by yellow color.
Function : =AVERAGEIF(B2:B13,F4,D2:D13)
4 Debit Average Amount
Here
calculated average amount in cell G5 which is highlighted by yellow color.
Function : =AVERAGEIF(B2:B13,F5,D2:D13)
5 Credit Average Amount
Here
calculated average amount in cell G6 which is highlighted by yellow color.
Function : =AVERAGEIF(B2:B13,F6,D2:D13)