How to use AVERAGEIF and AVERAGEIFS

In the earlier posts we have looked at using SUMIF, SUMIFS, COUTIF AND COUNTIFS. In this post lets see how to use AVERAGEIF and AVERAGEIFS, 

Lets look at the following example:

Let say I need to calculate the average quantity produced for each day.

First make a list of dates (unique).

=AVERAGEIF(E:E,A3,G:G)

Extend the formula as needed.

Let say i need the average by machine (1 to 9) and date then i need to use AVERAGEIFS. 

The results will be,

The formula is 

=AVERAGEIFS($U:$U,$S:$S,$A3,$T:$T,B$2)

Please note the quantity is in column U, dates in column S and machine number in column T.

I have added IFERROR function to get rid of #DIV/0! error

=IFERROR(AVERAGEIFS($U:$U,$S:$S,$A3,$T:$T,B$2),"")

Please leave your comments, thanks.