Forum Discussion
Multiplying Merged Cells
I have cells E and F merged into one cell and H and I merged into 1 cell, and I want to multiply the numbers in each of those merged cells and used the folllowing command and it did not work:
=Sum E20*G20
I also used parenthesis around the formula(E20*G20) also and still did not work.
Thanks in advance
4 Replies
I guess if (E and F merged) and (H and I merged), their multiplication will be =E20*H20
- I'm not sure if that is what the cells mean. The expression "would like to multiply the numbers in each of these merged cells" refers to the "cells E and F to one cell and H and I" or to the previous composition of the user?
The user has to explain that to us.
Better description (even better with one file), better solution.
Nikolino
I know I don't know anything (Socrates)
- Your formula is OK, if you remove the word "Summe" it will work.
Word "Summe" away and the formula will be as mr mtarler suggested 🙂
Enjoy Excel
Nikolino
I know I don't know anything (Socrates) - although I don't like merged cells, that is for other reasons. You should be able to simply use:
=E20*G20
At least it works for me. So if that doesn't work maybe there is something else going on.
