Google Sheets functions / Statistical
Statistical function · Google Sheets
AVERAGEA function
Average including text and logical values.
Reference entry. Syntax, tested examples and a practice file arrive with the full guide. Open the official function list.