P

#### Paul B

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