Tom’s Tutorials For Excel: SUMIF For Days Past Last Date

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
=LOOKUP(9.99999999999999E+307,A:A)
which returns the last number (in this case a date) in column A.

In cell E3 is the formula
=SUMIF(A5:A30,">="&(E1-E2),B5:B30)
that sums numbers in column B for dates up to 90 days past the last date.

Note that the number 90 is the criteria in cell E2.