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:

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" wrote in message
...
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:

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