Excel Magic Trick 1371

Excel Formula To Add Last Five Values in an Excel Table: INDEX Dynamic Range

DESCRIPTION

See how to Create Excel Formula To Add Last Five Values in an Excel Table using INDEX function to create a Dynamic Range inside the SUM Function. Topics:
(00:14) Introduction to add Last 5 in an Excel Table.
(01:38) INDEX to Look up the Last Value and the 5th from the last value.
(04:40) Copy and Paste Formulas Elements
(05:28) Final Formula with INDEX Function Dynamic Range and SUM Function.
(07:15) Summary
INDEX Function & Number Incrementor

WORKBOOKS

Download “Excel Magic Trick 1361-1380” Excel-Magic-Trick-1361-1380.zip – Downloaded 471 times – 14 MB







Be the first to comment

Leave a Reply