Weather counting query

[Weather Consultancy Services]

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: (e-mail address removed)

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

 

[Earl Kiosterud]

Simon,

You can use something like:

=AVERAGE(A2:A32)

This will ignore empty cells.