In order to average together values that match two different conditions in different ranges, an Excel user should use the Excel Average functions.To calculate average in Excel,the powerful Excel Average functions will do the work behind the scene. You use the AVERAGE function in Excel to return the average (arithmetic mean) of the specified cells. The different functions are : Excel AVERAGE - calculate the mean of cells with numbers. Excel AVERAGEA - find an average of cells with any data. Excel AVERAGEIF - average cells based on a given criterion. Excel AVERAGEIFS - average cells that match several criteria.