Spreadsheet: 264103d1378784134-daily-data-conversion-to-monthly-totals-raindata_excel_forum
Sheet: Pivot Table

Sum of Rain | Column Labels
Row Labels | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | Grand Total
Minna | 22.3 | 124.9 | 289.0000000000001 | 2044.5 | 5435.499999999999 | 6322.7 | 8640.6 | 10954 | 9127.900000000001 | 4414.6 | 114.6 | 11.2 | 47501.8
1970 |  |  |  |  |  |  | 169.2 | 341.4000000000001 | 341 | 68.5 | 0 | 0 | 920.1000000000001
1971 | 0 | 5.1 | 7.4 | 16.8 | 139.7 | 212.8 | 232.7 | 245.2 | 241.5999999999999 | 28.9 | 0 | 0 | 1130.2
1972 | 0 | 0 | 46.7 | 30.9 | 226.7000000000001 | 82.59999999999998 | 315.8 | 427.1999999999999 | 186.9 | 50.7 | 0 | 0 | 1367.5
1973 | 0 | 0 | 3.6 | 21.8 | 79.3 | 86.99999999999999 | 84.60000000000001 | 393.2 | 278.6 | 60.89999999999999 | 0 | 0 | 1009
1974 | 0 | 0 | 4.5 | 8.6 | 120.3 | 140.8 | 280.5 | 208 | 251.8 | 127.5 | 0 | 0 | 1142
1975 | 0 | 18.6 | 20.9 | 150.5 | 127.2 | 179.9 | 290.5 | 141.8 | 380 | 77.9 | 0 | 0 | 1387.3
1976 | 0 | 86.10000000000001 | 0 | 44.40000000000001 | 119.6 | 188.7 | 162.5 | 177 |  | 242.7 |  |  | 1021
1977 | 0 | 0 | 0 | 4.7 | 122.6 | 138.5 | 282.3999999999999 | 390.3 | 323.2 | 94.7 | 0 | 0 | 1356.4
1978 | 0 | 0 | 21.4 | 107.8 | 262.4 | 123.3 | 193.5 | 373.2 | 249.9 | 121.9 | 4.5 | 0 | 1457.9
1979 | 0 | 0 | 15.4 | 15.3 | 138.9 | 196.1 | 254 | 449.4 | 137.5 | 148.7 | 7.6 | 0 | 1362.9
1980 | 0 | 0 | 0 | 7.8 | 232.9 | 157.1 | 195.4 | 259.8 | 141.3999999999999 | 141.7 | 0 | 0 | 1136.1
1981 | 0 | 0 | 0 | 22.8 | 55.09999999999999 | 168.1 | 175.5 | 273.9999999999999 | 182.9 | 96.6 | 0 | 0 | 975
1982 | 0 | 0 | 13 | 66.8 |  |  | 301.9 | 293.7 | 163 | 99.1 | 0 | 0 | 937.5
1983 | 0 | 0 | 0 | 12.2 | 97 | 96.9 | 159.2 | 299.7 | 228.7 | 34 | 0 | 0 | 927.7
1984 | 0 | 0 | 3 | 54.60000000000001 | 81.19999999999999 | 114.3 | 214.8 | 163.6 | 170.1 | 73.30000000000001 | 0 | 0 | 874.9000000000001
1985 | 0 | 0 | 61.2 | 17.3 | 141.7 | 250.6 | 233.3 | 249.7 | 176.6 | 61 | 0 | 0 | 1191.4
1986 | 0 | 0 | 39.6 | 15.1 | 86 | 183.3 | 221.7 | 243 | 315.8 | 83.8 | 19.6 | 0 | 1207.9
1987 | 0 | 0 | 13.5 | 44.6 | 104.5 | 78.89999999999999 | 143.7 | 238.5 | 94.60000000000004 | 100.1 | 0 | 0 | 818.4000000000001
1988 | 10.5 | 0 | 0.1 | 57.9 | 94.6 | 135.5 | 175 | 309.4999999999999 | 382.1 | 36.9 | 0 | 0 | 1202.1
1989 | 0 | 0 | 7.3 | 48.9 | 215.1 | 250.8 | 188.2 | 206.4 | 179.6 | 85.19999999999999 | 0 | 0 | 1181.5
1990 | 0 | 0 | 0 | 107.4 | 199.5 | 94.9 | 198.6 | 181 | 187 | 141.4 | 0 | 0 | 1109.8
1991 | 0 | 0 | 0 | 114.5 | 336 | 180.1 | 192.9 | 268.5 | 190.8 | 33.89999999999999 | 0 | 0 | 1316.7
1992 |  | 0 | 1.3 | 158.2 | 176.8 | 162.9 | 196.4 | 231.5 | 230.3 | 46.6 | 37.9 | 0 | 1241.9
1993 | 0 | 0 | 13.5 | 8.600000000000001 | 174.3999999999999 | 170.5 | 189.7 | 271.1 | 178.3 | 63.3 | 0 | 0 | 1069.4
1994 | 0 | 0 | 7.3 | 72.5 | 114.4 | 239 | 142.5 | 367.2 | 261.3 | 208.1 | 0 | 0 | 1412.3
1995 | 0 | 0 | 0 | 100.5 | 123.2 | 144.5 | 153.7 | 408.9999999999999 | 189.1 | 135.7 | 23.6 | 0 | 1279.3
1996 | 0 | 0 | 0 | 48.6 | 164.7 | 225 | 259.7000000000001 | 256.9999999999999 | 191.1 | 127.9 | 0 | 0 | 1274
1997 | 0 |  | 3.6 | 80.6 | 238.4 | 233 | 172.4 | 192.7 | 203.3 | 115 | 6.1 | 0 | 1245.1
1998 | 0 | 0 | 0 | 82.5 | 121.2 | 221 | 155.1 | 243 | 201.9 | 212.6 | 0 | 0 | 1237.3
1999 | 0 | 7.9 | 0 | 35.7 | 102.8 | 164.2 | 243.9 | 245.1 | 237.1 | 212.2 | 0 | 0 | 1248.9
2000 | 0.6 | 0 | 0 | 3.6 | 135.9 | 161 | 208.8 | 308.4999999999999 | 302.9999999999999 | 153.4 | 0 | 0 | 1274.8
2001 | 0 | 0 | 0 | 93.9 | 139 | 331.7 | 244.6 | 230.2 | 298.8000000000001 | 25.7 | 0 | 0 | 1363.9
2002 | 0 | 0 | 5.7 | 98.80000000000001 | 42.6 | 201 | 143.2 | 226.5 | 260.6 | 180.3 | 0 | 0 | 1158.7
2003 | 0 | 5.7 | 0 | 17.1 | 114.6 | 213.1 | 123 | 191.6 | 188.2 | 192.4 | 2.3 | 0 | 1048
2004 | 0 | 0 | 0 | 32.2 | 151.9 | 194.9 | 210.3 | 211.4 | 241.5 | 77.60000000000001 | 0 | 0 | 1119.8
2005 | 0 | 0 | 0 | 49.1 | 86.99999999999999 | 207 | 294.2 | 127.8 | 216.6 | 94.80000000000001 | 0 | 11.2 | 1087.7
2006 | 11.2 | 0 | 0 | 29.9 | 195 | 107.7 | 229.7 | 317.1 | 360.4999999999999 | 172.1 |  | 0 | 1423.2
2008 |  |  |  |  |  |  | 305.1 | 244.3 | 258.9 | 141.2 | 0 | 0 | 949.5
2009 | 0 | 0 | 0 | 89.9 | 101.4 | 108.9 | 246.8 | 497.6 | 273.5 | 85.2 | 0 | 0 | 1403.3
2010 | 0 | 0 | 0 | 46.3 | 131.5 | 109.8 | 260.9 | 248.3 | 230.8 | 161.1 | 13 | 0 | 1201.7
2011 | 0 | 1.5 | 0 | 25.8 | 140.4 | 67.3 | 194.7 |  |  |  |  |  | 429.7
Grand Total | 22.3 | 124.9 | 289.0000000000001 | 2044.5 | 5435.499999999999 | 6322.7 | 8640.6 | 10954 | 9127.900000000001 | 4414.6 | 114.6 | 11.2 | 47501.8