I have rain fall data from 1-1-1989 to present



I am trying to get the amount of rain fall we should have to date, like you
see on the TV weather.



I have the dates in A2 down with a defined name as Dates, with this formula
=OFFSET(Data!$A$2,0,0,COUNTA(Data!$A:$A),1)



I have the amounts in B2 down with a defined name as Rainfall, with this
formula

=OFFSET(Data!$A$2,0,1,COUNTA(Data!$A:$A),1)



Data is only put in when there was rain fall, so all the dates for the years
are not there, would be like this, in A2 1-3-1989, B2 .09, in A3 1-8-1989,
B3 1.04, there are some T's in column B when there was only a trace for
that day



I have been tried some formulas but just can't get it, this is what I have
so far, may not even be close, I don't think the <=day part is right but..
The /20 is for the number of years, if this is right can it also be included
in the formula



Array formula



=SUM(IF(ISNUMBER(Dates)*ISNUMBER(Rainfall)*(MONTH( Dates)<=MONTH(TODAY()))*(DAY(Dates)<=DAY(TODAY())) ,Rainfall))/20



Thanks


Using Excel 2003