SOLVED

Add up 2 formulas in a cell

New Contributor

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 Replies
best response confirmed by Hans Vogelaar (MVP)
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.

sumproduct.JPG

That´s great!
Thank you very much.