Excel Forum
Similar Content
OFFSET Function in Excel
Tutorial: The OFFSET function in Excel returns a cell or range reference that is a specified number...
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...
Best Lookup Formula in Excel - Index and Match
Tutorial: A lookup using INDEX and MATCH is like a VLOOKUP without the restrictions.  Index and Ma...
Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course




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.