USE CONCATENATE function to connect 2 formulas

[Guest]

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,

 

[Bernie Deitrick]

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

 

[Aladin Akyurek]

Is it not just something like:

=SUM(A2:A100,B2:B100)

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.

 

[Kimmie]

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

 

[Bernie Deitrick]

Kimmie,

=A1 & ", " & B1

HTH,
Bernie
MS Excel MVP