SUMIF etc for dates & data

[Gallen]

Hi all,
I have 62 years worth of daily data, basically consisting
of a date entry and rainfall for that day. How can I
produce tables or summary lists of say monthly rainfall,
yearly rainfall etc.
As this set is 22,600 lines long, having the results
tabulated elsewhere, as opposed to next to the cumulative
month / week's entry point would be a huge plus.
cheers
GAllen

 

[JMay]

With dates beginning in Column A, cell A3 and Downward - Enter in B3 (and
copy downward):

=IF(AND(YEAR(A3)>1925,YEAR(A3)<2000),"19"&RIGHT(YEAR(A3),2)&"-"&TEXT(MONTH(A
3),"00"),"20"&RIGHT(YEAR(A3),2)&"-"&TEXT(MONTH(A3),"00"))