Is there a way to combine two formulas in adjecent cells into one single
formula?
It is important that the resulting cell contains the formula that is in each
of the source cells summed together. It can not be simply a new function
that adds the 2 cells together.

EG. CELL A1 contains the formula: =Sum(A2:A100)
Cell B1 Contains the formula: =Sum(B2:B100)

New cell in C1 must contain the formula =Sum(A2:A100)+Sum(B2:B100).
Thank you,