Excel AVERAGEA Function
What is the Excel AVERAGEA Function? The excel AVERAGEA function calculates like the excel AVERAGE function. The AVERAGE function and the AVERAGEA function return different results when there are logical values (TRUE / FALSE), empty text or text representations of numbers. The AVERAGE function ignores these …