Forum Discussion
Solved
Add up 2 formulas in a cell
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.
=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(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.
- That´s great!
Thank you very much.
