Excel Forum
Similar Content
Dynamic Formulas that Update When you Add Data in Excel
Tutorial: I'll show you how to make formulas and functions that automatically update when more data...
OFFSET Function in Excel
Tutorial: The OFFSET function in Excel returns a cell or range reference that is a specified number...
Best Lookup Formula in Excel - Index and Match
Tutorial: A lookup using INDEX and MATCH is like a VLOOKUP without the restrictions.  Index and Mat...

Excel Magic Trick 678: SUM only Values After Deadline Dynamic Range using INDEX Function.

See how SUM only the Values After the Deadline using a Dynamic Range formula using INDEX Function. Also see a SUMPRODUCT function method.

Download file: http://flightline.highline.edu/mgirvin/ExcelIsFun.htm

Got a Question? Ask it Here in the Forum.