SOLVED

# Add up 2 formulas in a cell

Copper 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 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

# Re: Add up 2 formulas in a 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.

# Re: Add up 2 formulas in a cell

That´s great!
Thank you very much.
1 best response

Accepted Solutions
best response confirmed by Hans Vogelaar (MVP)
Solution

# Re: Add up 2 formulas in a 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.