Excel table with different formula in first line

[Excelcute]

Hello guys,
I have a small Excel issue and I hope you can help me.
I have a fomatted table with formulas in it. The plan is to have the first line different because there is no data in the line above (this is the headline). For all other lines, the formula should link to the upper line. The problem is, that the formula will not be copied automatically because this line is different, in the table on the right side, where all formulas are the same, it worked. Any idea how to solve this?
excelprob.JPG

Thank you very much!

[TMS]

For the first row, use

Please Login or Register  to view this content.

[Excelcute]

Thank you very much, that worked great!
But what happens if I need a completely different formula in the first line? Is there a way to protect this somehow and still use the autoformulas in the following lines, from the 2nd line?
Thanks!

[oeldere]

E5=sum($D$5:$D5)

[TMS]

You're welcome. Thanks for the rep.


To the rider question: short answer, no, NAFAIAA. You probably need to rethink your formulae.

[XOR LX]

You could use:

=IF(ROWS(INDEX([Important Data],1):[@[Important Data]])=1,MyFirstRowFormula,MyOtherRowsFormula)

Replace MyFirstRowFormula and MyOtherRowsFormula as appropriate.

Regards