Spreadsheet: 145136d1331314696-countif-function-help-climate-station-2012-1-
Sheet: January

DATE |  | Wind |  | Present Weather | Visibility | Temperatures (°C) |  |  |  |  |  |  |  |  |  | state of | state of | Snow | Rainfall | Sunshine
 | Total | Dir. | speed |  |  |  |  | [NAME] |  |  |  |  | Soil |  | 0900 | ground | ground | Depth | 09-09h |  | Weather 00 hrs - 24 hrs
 | cloud | Whole | knots |  |  | Dry | Wet | thrown |  |  |  |  |  |  | mb | without | with | Whole | Thrown back |  | snow
 |  | deg,s |  |  |  | bulb | bulb | Back | Min | Grass | Conc | 30cm | 50cm | 100cm | Press | snow | snow | cm | mm & 10ths |  | sleet | Hail/Ice | Thunder | Gale |  | deg,s
1 | 8 | 270 | 5 | 2 | 6 | 7.2 | 5.6 | 8.2 | 5.1 | 2.4 | 3.6 | 6.6 | 6.4 | 6.8 | 994 | 1 |  |  | 3.5 | 0.3 | 0 | 1 | 0 | 0 |  | 0 | N
2 | 2 | 230 | 9 | 2 | 7 | 3.8 | 1.7 | 12.5 | 2.5 | -1.1 | -0.2 | 5.8 | 6.4 | 6.8 | 996 |  | 0 | tr hail | 5.3 | 1.4 | 0 | 1 | 0 | 0 |  | 20 | NNE
3 | 8 | 270 | 37 | 21 | 6 | 7.3 | 5.5 | 8.8 | 1.9 | -0.4 | 0 | 5.2 | 6 | 6.8 | 977 | 1 |  |  | 1 | 0.4 | 0 | 0 | 0 | 1 |  | 50 | NE
4 | 8 | 250 | 13 | 21 | 6 | 5.1 | 4 | 8.6 | 1.8 | -0.5 | 0.4 | 5.1 | 5.7 | 6.8 | 1008 | 1 |  |  | 13.6 | 0 | 0 | 0 | 0 | 1 |  | 70 | ENE
5 | 7 | 270 | 19 | 15 | 6 | 5 | 3.8 | 6.4 | 4.3 | 1.8 | 2.9 | 5.3 | 5.6 | 6.7 | 991 | 1 |  |  | 0 | 4.6 | 0 | 0 | 0 | 0 |  | 90 | E
6 | 3 | 230 | 5 | 2 | 7 | 2.8 | 1.8 | 9.4 | 1.3 | -3.3 | -2.2 | 4.6 | 5.5 | 6.7 | 1022 | 4 |  |  | 0.9 | 0.3 | 0 | 0 | 0 | 0 |  | 110 | ESE
7 | 7 | 270 | 13 | 80 | 7 | 6.1 | 4.4 | 7.4 | 2.5 | -1.9 | -1.1 | 5 | 5.3 | 6.5 | 1016 | 1 |  |  | 0.3 | 0 | 0 | 0 | 0 | 0 |  | 140 | SE
8 | 8 | 250 | 9 | 2 | 6 | 6.6 | 6 | 9.6 | 5.9 | 2.8 | 4 | 5.2 | 5.5 | 6.3 | 1022 | 1 |  |  | 1.5 | 0 | 0 | 0 | 0 | 0 |  | 160 | SSE
9 | 8 | 270 | 13 | 2 | 6 | 8.4 | 8 | 8.7 | 6.6 | 5.1 | 5.6 | 5.9 | 5.9 | 6.4 | 1021 | 1 |  |  | 0 | 3.9 | 0 | 0 | 0 | 0 |  | 180 | S
10 | 7 | 230 | 9 | 2 | 8 | 6.3 | 4.6 | 9.6 | 4.2 | -0.7 | 1 | 5.7 | 5.9 | 6.4 | 1027 | 1 |  |  | 0.7 | 0 | 0 | 0 | 0 | 0 |  | 200 | SSW
11 | 7 | 230 | 9 | 2 | 7 | 8.3 | 7.8 | 10.6 | 6.3 | 4.5 | 5.3 | 6.3 | 6.1 | 6.5 | 1027 | 1 |  |  | 1.4 | 0 | 0 | 0 | 0 | 0 |  | 230 | SW
12 | 8 | 290 | 13 | 2 | 7 | 7.2 | 6.6 | 7.2 | 7.2 | 4.4 | 5.5 | 6.9 | 6.5 | 6.5 | 1019 | 1 |  |  | 0 | 4.2 | 0 | 0 | 0 | 1 |  | 250 | WSW
13 | 4 | 180 | 2 | 2 | 7 | 0.2 | -0.3 | 4.8 | -0.3 | -6.2 | -3.3 | 5.7 | 6.4 | 6.8 | 1033 | 4 |  |  | 0 | 4.9 | 0 | 0 | 0 | 0 |  | 270 | W
14 | 5 | 160 | 5 | 1 | 7 | 1.4 | 0.2 | 5.2 | -2 | -8.6 | -5.3 | 4.3 | 5.5 | 6.7 | 1028 | 4 |  |  | 0 | 6.1 | 0 | 0 | 0 | 0 |  | 290 | WNW
15 | 2 | 140 | 2 | 2 | 7 | -0.8 | -1.6 | 4.9 | -0.9 | -7.6 | -5 | 3.5 | 4.9 | 6.4 | 1024 | 4 |  |  | 0 | 3.7 | 0 | 0 | 0 | 0 |  | 320 | NW
16 | 1 | 160 | 2 | 2 | 7 | -0.2 | -1.1 | 4.8 | -0.9 | -7.5 | -5.3 | 2.9 | 4.3 | 6.1 | 1024 | 4 |  |  | 0 | 6.2 | 0 | 0 | 0 | 0 |  | 340 | NNW
17 | 6 | 70 | 5 | 5 | 6 | 0.7 | -0.2 | 10.1 | -0.6 | -6.8 | -4.7 | 2.6 | 3.8 | 5.7 | 1023 | 4 |  |  | 4.1 | 0.4 | 0 | 0 | 0 | 0 |  | 360 | N
18 | 8 | 230 | 9 | 21 | 7 | 8.4 | 7.2 | 8.4 | 0.5 | -4.1 | -2.3 | 3 | 3.5 | 5.3 | 1014 | 1 |  |  | 0.4 | 0 | 0 | 0 | 0 | 0
19 | 8 | 270 | 13 | 2 | 7 | 3.8 | 3 | 6.3 | 3.8 | 1.4 | 3.4 | 3.2 | 3.6 | 5.4 | 1012 | 1 |  |  | 1 | 2 | 0 | 0 | 0 | 0
20 | 8 | 250 | 9 | 2 | 6 | 3.5 | 2.9 | 8.9 | 1.5 | -1.7 | 0.1 | 3.3 | 3.9 | 5.5 | 1013 | 1 |  |  | 6.3 | 0 | 0 | 0 | 0 | 0
21 | 7 | 270 | 19 | 25 | 6 | 5.7 | 4.8 | 7.6 | 3.5 | 1.2 | 2 | 4.2 | 4.3 | 5.2 | 1002 | 1 |  |  | 2.7 | 0.5 | 0 | 0 | 0 | 0
22 | 8 | 270 | 19 | 81 | 5 | 6.5 | 5.5 | 7.3 | 4.6 | 1.9 | 3.5 | 4.3 | 4.5 | 5.3 | 1001 | 1 |  |  | 0.6 | 3 | 0 | 0 | 0 | 0
23 | 3 | 270 | 9 | 2 | 8 | 2.7 | 2.2 | 5.5 | 2.5 | -1.2 | 0.1 | 4.3 | 4.7 | 5.4 | 1013 | 4 |  |  | 6.7 | 2 | 0 | 0 | 0 | 0
24 | 8 | 110 | 2 | 61 | 5 | 2.9 | 2.5 | 9.2 | 2 | -3.1 | -1.4 | 3.7 | 4.5 | 5.4 | 1013 | 1 |  |  | 2.7 | 0 | 0 | 0 | 0 | 0
25 | 8 | 230 | 0 | 2 | 7 | 8.8 | 7.1 | 10.3 | 2.6 | 1.5 | 2.3 | 4.4 | 4.5 | 5.3 | 1007 | 1 |  |  | 2 | 1.3 | 0 | 0 | 0 | 0
26 | 3 | 160 | 2 | 2 | 7 | 2.4 | 1.8 | 5.2 | 1.1 | -4.1 | -1.3 | 4.4 | 5 | 5.3 | 996 | 4 |  |  | 5.5 | 0.9 | 1 | 0 | 0 | 0
27 | 8 | 270 | 9 | 84 | 5 | 2.8 | 2.3 | 3.8 | 0.9 | -2.2 | -0.6 | 4.4 | 4.9 | 5.5 | 1011 | 1 |  |  | 2.1 | 0.2 | 1 | 0 | 0 | 0
28 | 5 | 0 | 0 | 2 | 6 | -0.7 | -1.1 | 2.7 | -1.8 | -7.4 | -3.6 | 3.8 | 4.7 | 5.5 | 1030 | 4 |  |  | 0 | 1.9 | 0 | 0 | 0 | 0
29 | 8 | 110 | 5 | 2 | 8 | 0 | -0.6 | 3.2 | -1.9 | -7.4 | -3.4 | 3 | 4.1 | 5.3 | 1030 | 4 |  |  | tr | 0 | 0 | 0 | 0 | 0
30 | 8 | 90 | 5 | 2 | 8 | -0.3 | -1.3 | 2.9 | -1.2 | -5.8 | -3.2 | 2.8 | 3.7 | 5.2 | 1028 | 4 |  |  | tr | 2.8 | 5 | 0 | 0 | 0
31 | 8 | 90 | 2 | 27 | 6 | 0.6 | -0.2 | 2.6 | -0.7 | -5 | -3.2 | 2.4 | 3.4 | 3.4 | 1028 | 4 |  |  | tr | 0 | 5 | 0 | 0 | 0
 |  |  |  |  |  |  |  | [NAME] | Min | Grass | Conc | 30cm | 50cm | 100cm | Press |  |  |  | Rainfall | Sun | Sl/Sn | Hail | Th | Gale
Total
Mean
Highest [NAME] °C |  |  | on: | 2nd |  |  |  |  | Number of days with: |  |  |  |  |  |  | Rainfall |  |  |  |  | Total | % | 10yr [NAME]
Lowest [NAME] °C |  |  | on: | 31st |  |  |  |  | Air min below 0.0°C
Lowest min °C |  |  | on: | 14th |  |  |  |  | Grass min below 0.0°C |  |  |  |  |  |  | Greatest fall in 24 hrs 09-09h: |  |  |  |  |  | On: | 4th
Highest min °C |  |  | on: | 12th |  |  |  |  | Concrete min below 0.0°C |  |  |  |  |  |  | Number of days with 0.2 mm or more:
[NAME] °C |  |  | on: | 14th |  |  |  |  |  |  |  |  |  |  |  | Number of days with 1.0 mm or more:
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Number of days with 5.0 mm or more:
[NAME] °C |  |  |  | Wind Direction 0900hrs
Mean Min °C |  |  |  | N | NE | E | SE | S | SW | W | NW | [NAME] |  |  |  | [NAME] |  |  |  | Fog at 0900hrs
Mean °C |  |  |  | 0 | 1 | 2 | 6 | 0 | 9 | 10 | 1 | 1 |  |  |  | 60.9knots 2nd