Goal: Calculate the average score.
Watch how Text and Boolean (True/False) values are treated differently.
Ready...
💻 Formula Structure
=AVERAGE(number1, [number2], ...)
- Logic: Adds numbers. Ignores Text and Logical values (True/False).
=AVERAGEA(value1, [value2], ...)
- Logic: Text = 0. TRUE = 1. FALSE = 0.
- Use Case: When you want non-numbers to drag the average down.
-- Select a function...
...
⚠️ Common Pitfalls
🚫 Empty vs Zero
An Empty Cell is ignored by both functions.
A Zero (0) is counted by both.
Be careful with blank cells vs cells containing "0".
🚫 Numbers stored as Text
AVERAGE ignores "10" (text). AVERAGEA treats "10" (text) as 0.
Always convert text-numbers to real numbers first!