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,

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,

Is it not just something like:

=SUM(A2:A100,B2:B100)

Jordan wrote:
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,

--

[1] The SumProduct function should implicitly coerce the truth values to
their Excel numeric equivalents.
[2] The lookup functions should have an optional argument for the return
value, defaulting to #N/A in its absence.

Is there a way to combine two cells and have it show up with a comma between
the last name and first name:

Phillips Steve

....and make it appear as Phillips, Steve when the name is combined using
this formula:

=CONCATENATE(A1," ",B1) - COMBINE CELLS

Kimmie,

=A1 & ", " & B1

HTH,
Bernie
MS Excel MVP


"Kimmie" wrote in message
...
Is there a way to combine two cells and have it show up with a comma
between
the last name and first name:

Phillips Steve

...and make it appear as Phillips, Steve when the name is combined using
this formula:

=CONCATENATE(A1," ",B1) - COMBINE CELLS