Accumulation over previous 60 days
I would like to calculate the rainfall over the last 60 days (not really, but it's a simple example) and subtract from a maximum allowable amount. I have the rainfall amounts and dates for the past year. The final calculation is to subtract the total from the last 60 days from 500. Suggestions?