Add up 2 formulas in a cell

[SimeonLesan]

Hey guys, i was wandering if is possible to write 2 formulas in one cell and add them up.

In my case i want to use 2 =PRODUCT formals to multiply 2 cells for each formula but i want the final number to be the addition of those 2 formulas.

I know that i can just use 2 more cells for each formula and on a 3rd cell add the results, but it would be great if this was possible in only 1 cell.

[#2 · Accepted solution]

@SimeonLesan 

=SUMPRODUCT(B2:B3,C2:C3)

Maybe with SUMPRODUCT. In the example the goal is to multiply 2 times 3 and 4 times 5 and then add up the products.

[#3]

That´s great!
Thank you very much.