Question: what is the difference between average and averagea in excel?
Answer: The AVERAGEA function returns the average (arithmetic mean) of a group of supplied values. The key difference between AVERAGEA and AVERAGE is AVERAGEA will also evaluate the logical values TRUE and FALSE, and numbers represented as text when when they appear in cell references, whereas AVERAGE just skips these values.