software

I have some prices in cells A1 to A20 I know how to get the average price if
all the cells have a price in it, but how do I get an average if say only
some of the cells have the information in them.
ie if 10 cells have a price and 10 cells dont I could divide by 10 to get an
average but this will obviously change as I add more prices in so looking
for a way to avoid me having to manually adjust the average figure each time
I add a new entry.

thanks
=SUM(A1:A20)/COUNT(A1:A20)

--
Kind regards,

Niek Otten

quot;S Squot; gt; wrote in message o.uk...
|I have some prices in cells A1 to A20 I know how to get the average price if
| all the cells have a price in it, but how do I get an average if say only
| some of the cells have the information in them.
| ie if 10 cells have a price and 10 cells dont I could divide by 10 to get an
| average but this will obviously change as I add more prices in so looking
| for a way to avoid me having to manually adjust the average figure each time
| I add a new entry.
|
| thanks
|
|
One way:

=AVERAGE(A1:A20)

will ignore blanks.

In article gt;,
quot;S Squot; gt; wrote:

gt; I have some prices in cells A1 to A20 I know how to get the average price if
gt; all the cells have a price in it, but how do I get an average if say only
gt; some of the cells have the information in them.
gt; ie if 10 cells have a price and 10 cells dont I could divide by 10 to get an
gt; average but this will obviously change as I add more prices in so looking
gt; for a way to avoid me having to manually adjust the average figure each time
gt; I add a new entry.
gt;
gt; thanks

Thnaks thats working for me.

quot;JE McGimpseyquot; gt; wrote in message
...
gt; One way:
gt;
gt; =AVERAGE(A1:A20)
gt;
gt; will ignore blanks.
gt;
gt; In article gt;,
gt; quot;S Squot; gt; wrote:
gt;
gt;gt; I have some prices in cells A1 to A20 I know how to get the average price
gt;gt; if
gt;gt; all the cells have a price in it, but how do I get an average if say only
gt;gt; some of the cells have the information in them.
gt;gt; ie if 10 cells have a price and 10 cells dont I could divide by 10 to get
gt;gt; an
gt;gt; average but this will obviously change as I add more prices in so looking
gt;gt; for a way to avoid me having to manually adjust the average figure each
gt;gt; time
gt;gt; I add a new entry.
gt;gt;
gt;gt; thanks