Tag Archives: AVERAGE

Average Trap 2 – Average the average

Why we cannot take the average of averages? Once upon a time, I was questioned with the above.  First thing on my mind: “Is it a test?”… So I answered the question carefully, as shown in the screen shot below:

Rate this:

Posted in Formula | Tagged | 1 Comment

Average Trap

What do you mean by “Average”? When the question “What is the average of…” is asked, the top of mind function could possibly be AVERAGE.  But did you know that AVERAGE function ignores text (including number stored as text), logical … Continue reading

Rate this:

Posted in Formula | Tagged , | Leave a comment