Weather counting query

Hi All,

I have entered data for several weather stations into Excel. They are daily
maximum temperatures.

What I would like to do is to totalthe temperatures and then divide them by
the number of days in the month,

Obviously, this number varies, so I would like to count the number of cells
with an entry in it, and then divide the total maximum temperatures by that
figure. This should also give me a running total of the average temperature
for each stationat anytime in the month.

Can anyone suggest how I can do this?

Thanks in advance,
Simon Keeling

--
Weather Consultancy Services
The Weather Centre, 188 Common Road, Wombourne, South Staffordshire. WV5
0LT.
Tel: 01902 895252
email: simon@weatherweb.net

http://www.weatherweb.net
http://www.weatherschool.co.uk
http://www.atlanticweather.co.uk

Simon,

You can use something like:

=AVERAGE(A2:A32)

This will ignore empty cells.
--
Earl Kiosterud
www.smokeylake.com

"Weather Consultancy Services" <simon@weatherweb.net> wrote in message
news:ScQGe.6962$CF.48149@news-1.opaltelecom.net...
> Hi All,
>
> I have entered data for several weather stations into Excel. They are
> daily maximum temperatures.
>
> What I would like to do is to totalthe temperatures and then divide them
> by the number of days in the month,
>
> Obviously, this number varies, so I would like to count the number of
> cells with an entry in it, and then divide the total maximum temperatures
> by that figure. This should also give me a running total of the average
> temperature for each stationat anytime in the month.
>
> Can anyone suggest how I can do this?
>
> Thanks in advance,
> Simon Keeling
>
> --
> Weather Consultancy Services
> The Weather Centre, 188 Common Road, Wombourne, South Staffordshire. WV5
> 0LT.
> Tel: 01902 895252
> email: simon@weatherweb.net
>
> http://www.weatherweb.net
> http://www.weatherschool.co.uk
> http://www.atlanticweather.co.uk
>