Creation of a "dynamic" formula

  • Hi,

    I'd like to create a formula that would be generated based on the input in two other cells.

    The input in those two cells would represent the cells (location) where the formula should start and where it should end.

    For example, I'd like to create a SUM formula that would take input from such two cells as start and end of calculation.

    I'm attaching an example.

    Thank you and best regards.

  • INDIRECT() is the simplest way to do this but it is a volatile function - it'll recalculate every time any other formula is recalculated (Like the NOW() function). It's not usually a problem but in a big workbook a lot of volatile functions could start to be a drain on resources... just something to bear in mind.


    Nice to see a self-answered Q

    Edited 2 times, last by cytop ().

  • INDIRECT() is the simplest way to do this but it is a volatile function - it'll recalculate every time any other formula is recalculated (Like the NOW() function). It's not usually a problem but in a big workbook a lot of volatile functions could start to be a drain on resources... just something to bear in mind.


    Nice to see a self-answered Q

    Thank you, noted!

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!