Examples
=AVERAGEA(A1:D1) returns 2.5 if cells A1 through D1 contain 4, a, 6, b. The text values are counted as zeros in the sum of 10 and included in the count of values (4). Compare with =AVERAGE(A1:D1), which ignores the text values completely for a sum of 10, a count of 2, and an average of 5.
=AVERAGEA(A2:D2) returns 4 if cells A2 through D2 contain 5, a, TRUE, 10. The text value counts 0 and TRUE counts 1 for a sum of 16 and a count of 4.
=AVERAGEA(A3:D3) returns 0.25 if cells A3 through D3 contain FALSE, FALSE, FALSE, TRUE. Each FALSE counts 0 and TRUE counts 1 for a sum of 1 and a count of 4.
=AVERAGEA("12/31/2010", "3d") returns an error as the values provided include both date/time and duration values.