Tom’s Tutorials For Excel: SUMIF For Days Past Last Date
Here’s an example of two formulas working in tandem for a common goal.
In cell E1 is the formula
which returns the last number (in this case a date) in column A.
In cell E3 is the formula
that sums numbers in column B for dates up to 90 days past the last date.