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 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.
In cell D36 you have formula =30:294001 which means you instruct Excel to return all rows from 30 to 294001. Includes row in which the formula is. Kind of cyclic reference and never ended loop.
If you remove this formula it works.
2 Replies
Sort By
- OliverScheurichGold 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.
- SimeonLesanCopper ContributorThat´s great!
Thank you very much.