Jordan,

No way using worksheet functions. You could use VBA, but there isn't any
reason to do so. Simply using =A1+B1 will be the equivalent, and be less
error prone.

HTH,
Bernie
MS Excel MVP


"Jordan" wrote in message
...
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,