Repeating rows at the bottom with formula

[Marowaks]

I know you can make static rows repeat at the bottom with custom footers. However, it is limited to what footer options allow you. I wanted to see if there was a way to make rows repeat at the bottom that had formulas written into it. It is preferable to do so with out macro help as well. I understand if it is not. Anyone's help on this is very appreciated. Thanks.