finding average, including empty cells and cells have text

[lezawang]

Hi
I wanted to find the average of A1:A10. To my surprised when I changed A1 = test and deleted A3 and A7 content, the average remain the same.
Why is that? what is the value of empty cells? what is the value of cells which has text? these values should change the average? should not? thank you.

Book1
	A	B	C
1	test		average
2	2		2
3
4	2
5	2
6	2
7
8	2
9	2
10	2
Sheet4

Cell Formulas
Range	Formula
C2	C2	=AVERAGE(A1:A10)

 

[mrshl9898]

They have no value, the AVERAGE just counts cells with values