Forum Discussion

SimeonLesan's avatar
SimeonLesan
Copper Contributor
Sep 22, 2022

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...
  • OliverScheurich's avatar
    Sep 22, 2022

    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.

Resources