In order to average together values that match two different conditions in different ranges, an Excel user should use the Excel Average functions.<span>To calculate average in Excel,the powerful Excel Average functions will do the work behind the scene. </span>You use the AVERAGE function in Excel to return the average (arithmetic mean) of the specified cells. The different functions are : <span><span>Excel AVERAGE - calculate the mean of cells with numbers. </span><span>Excel AVERAGEA - find an average of cells with any data. </span><span>Excel AVERAGEIF - average cells based on a given criterion. </span><span>Excel AVERAGEIFS - average cells that match several criteria.</span></span>
False you have to move your fingers
It’s false I hope this helped you