Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Web Query Help... | Excel Discussion (Misc queries) | |||
"Query cannot be edited by the Query Wizard" | Excel Discussion (Misc queries) | |||
Counting Data From A Query | Excel Worksheet Functions | |||
Query of External Data | Excel Discussion (Misc queries) | |||
How to use a Access Query that as a parameter into Excel database query | Excel Discussion (Misc queries) |