Main Profile

At A Glance

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
Length: 07:22

Contact

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

Want more info about Mr Excel & excelisfun Trick 34: Dynamic Range for Adding Three Methods? Get free advice from education experts and Noodle community members.

  • Answer

Ask a New Question