The program has been designed to expand a range in a formula so that it will point to all the inserted rows. If that is not what you want, would it work to add the cells like =B2+C2+D2 instead of using the sum function?
Thank you.
Larry
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hi,
thank you for this great program.
I have a csv like this:
C1,C2,C3,C4,C5,C6,C7,C8
bla,,,,,0.015,,184.434
bla1,3,,55,,12,2,,184.434
In template, I have the same first two rows. Just that I have in 9th and 10th column formulas like =SUM(B2:D2) and =SUM(E2:H2)
When file is generated, all formulas are like =SUM(B2:D11) and =SUM(E2:H11)
11 is the first empty row. Why this changes when file is generated? Please help.
Thank you and BR
Hi,
The program has been designed to expand a range in a formula so that it will point to all the inserted rows. If that is not what you want, would it work to add the cells like =B2+C2+D2 instead of using the sum function?
Thank you.
Larry
Hi Larry,
thank you very much for your response. It worked! I thought I've tried that...
Best regards