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.

I think I found the solution.

The formula that should be used in conjuction with the SUM is INDIRECT.

I'm attaching the same file, but with the correct formula.

Of course, if there's any other - more elegant way - I'm happy to hear about it!

Thanks.

Quote from 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!