AVERAGEA will include the logical values TRUE and FALSE, and numbers represented as text in the calculation.
TheAVERAGE functionignores these values during calculation
AVERAGEA takes multipleargumentsin the form ofvalue1, value2, value3, etc.
up to 255 total.
Arguments can include numbers, cell references, ranges, arrays, and constants.
Empty cells are ignored, but zero (0) values are included.
you’ve got the option to see this behavior in the worksheet example shown above.
