Calculate average with missing values

A

Arne Hegefors

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!
 
P

Pete_UK

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
 
J

JE McGimpsey

One way:

=AVERAGE(A1:A3)


AVERAGE() ignores text.

If you may not have ANY numeric values in A1:A3, then perhaps:

=IF(COUNT(A1:A3),AVERAGE(A1:A3),"No Values")
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top