SUMIF etc for dates & data

  • Thread starter Thread starter Gallen
  • Start date Start date
G

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
 
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"))
 
Back
Top