Concatenate two formulas

[opazzo]

Hi there,

Can't find a solution for this problem, I feel I miss something.

I have different sumproducts formulas in A2 to A100.

I want to reuse the same formulas and expand those with a new constant criteria from B2 to B100 but I don't want to retype as the formulas are quite long.

And I need to keep both results from A and B.

I tried concatenate and & but it just returns the values, not the formula behind.

Any suggestion ?

 

[DauntingGecko]

Split your long formula out into different cells and then make a "total" cell. Then you can use pieces of the formula you need.

 

[opazzo]

Not sure to see how this would work... I cannot really split the formula.

 

[opazzo]

Anybody ? Any idea on how to combine two formulas from different cells ?