Need dynamic sum formula

[blcexcel]

I'm looking for a method to create sum formulas dynamically.

I'm creating a report where there will be a data tab and then users will be setting the report tab themselves. They want the flexibility to group information as they wish. But I want to make it as user friendly as possible. And one challenge is there are many columns on the report. It would be time consuming if they had to manually create sum formulas for all the subtotal rows.

I created a solution using indirect formulas where the users enter the start row and end row and that is referenced in all the sum formulas. That works but makes the spreadsheet totally inflexible because the indirect formulas don't adjust if a column is added or removed.

Attached is a extremely simple version of what I'll working on.

Thanks in advance for any ideas!!!

 

[NARAYANK991]

Hi ,

My first suggestion is upload your working file , rather than a simple version which may or may not bear any relation to your working file.

What will be the user input based on which the output should vary ?

Where is this user input in the uploaded file ?

Narayan

 

[narunfca]

Hi,

Enclosed the file. Hope this helps.

with best regards

Arun N