Multiplying Merged Cells

[Mowog]

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

[#2]

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.

[#3]

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)

[#4]

@Mowog 

I guess if (E and F merged) and (H and I merged), their multiplication will be =E20*H20

[#5]

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)