Forum Discussion
SimeonLesan
Sep 22, 2022Copper Contributor
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 num...
- Sep 22, 2022
=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.
OliverScheurich
Sep 22, 2022Gold Contributor
=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.
SimeonLesan
Sep 22, 2022Copper Contributor
That´s great!
Thank you very much.
Thank you very much.