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)



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


That´s great!
Thank you very much.