Weather counting query

  • Thread starter Weather Consultancy Services
  • Start date
W

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: [email protected]

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

Earl Kiosterud

Simon,

You can use something like:

=AVERAGE(A2:A32)

This will ignore empty cells.
 
Top