Calculate average with missing values
This will still give you the average of the cells which contain
numbers:
=AVERAGE(A1:A3)
For example, A1 = 1, A2 = "text", A3 = 2 gives B1 = 1.5.
Hope this helps.
Pete
On Jan 14, 9:46*am, Arne Hegefors
wrote:
Hi! In column *A I have values in some cells and "#MISSING!" in some cells.
In column B I want to calculate the average value of e.g. A1 to A3. How can I
do that when some values are missing? Thanks!
|