average price

[S S]

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

 

[Niek Otten]

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

--
Kind regards,

Niek Otten

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

 

[JE McGimpsey]

One way:

=AVERAGE(A1:A20)

will ignore blanks.

 

[S S]

Thnaks thats working for me.

One way:

=AVERAGE(A1:A20)

will ignore blanks.