Excel Forum
Similar Content
Ignore Blanks in a Data Validation List in Excel
Tutorial: I will show you 3 ways to remove the blanks from a Data Validation dropdown menu in Exce...
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...
Group Data Together for Increased Readability in Excel
Tutorial: How to group data together or collapse it in order to focus only on the important data in...



Mr Excel & excelisfun Trick 34: Dynamic Range for Adding Three Methods


See Mr Excel and excelisfun add a range of values that is dynamic in two directions. The range of values to add changes depending on what you select from a drop-down list. See the SUM, OFFSET, MATCH, DATEVALUE, MONTH, and INDEX functions.
Learn about how the INDEX function can return a Cell Reference instead of a value.

Excel Magic Trick 423: INDEX Delivers Cell Reference - Sum Dynamic Range Without OFFSET Function





Got a Question? Ask it Here in the Forum.