AVERAGEA

Returns the average of the arguments, including text (valued as 0).

Syntax:

AVERAGEA(value1, value2, ... value30)

value1 to value30 are up to 30 values or ranges, which may include numbers, text and logical values. Text is evaluated as 0. Logical values are evaluated as 1 (TRUE) and 0 (FALSE).

Example:

AVERAGEA(2, 6, 4)

returns 4, the average of the three numbers in the list.

AVERAGEA(B1:B3)

where cells B1, B2, B3 contain 4, 2, and apple returns 2, the average of 4 and 2 and 0.

AVERAGEA(2, TRUE)

returns 1.5, the average of 2 and 1.

Application:

Let's imagine you are a manager at a small company and you're tracking employee performance on a project. You have a spreadsheet with the following data:

	Employee	Tasks Completed	Quality Rating	Project On Time?
	A	B	C	D
1	Alice	10	9	TRUE
2	Bob	8	N/A	FALSE
3	Charlie	12	10	TRUE
4	David	7	Good	FALSE

You want to calculate the average "performance score" for your team. You decide to use the following columns to determine the average score: Tasks Completed, Quality Rating, and Project On-time.

Here's how AVERAGEA would work on this data:

Let's say the table above is in a spreadsheet with the following cell references:

Alice's row: B1:D1
Bob's row: B2:D2
Charlie's row: B3:D3
David's row: B4:D4

If you were to use AVERAGEA on the data for each employee, the function would interpret the values as follows:

Alice's score: AVERAGEA(B1:D1)
- Values: 10, 9, TRUE
- AVERAGEA interprets: 10, 9, 1
- Calculation: (10 + 9 + 1) / 3 = 6.67

Bob's score: AVERAGEA(B2:D2)
- Values: 8, "N/A", FALSE
- AVERAGEA interprets: 8, 0, 0
- Calculation: (8 + 0 + 0) / 3 = 2.67

Charlie's score: AVERAGEA(B3:D3)
- Values: 12, 10, TRUE
- AVERAGEA interprets: 12, 10, 1
- Calculation: (12 + 10 + 1) / 3 = 7.67

David's score: AVERAGEA(B4:D4)
- Values: 7, "Good", FALSE
- AVERAGEA interprets: 7, 0, 0
- Calculation: (7 + 0 + 0) / 3 = 2.33

Result of Alice's Score:

6.67

Result of Bob's Score:

2.67

Result of Charlie's Score:

7.67

Result of David's Score:

2.33