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.
Leave a Reply