AVERAGEIF Function In Excel

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)



Post a Comment

0 Comments