# Multiplying Merged Cells

Occasional Visitor

# 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.

4 Replies

# Re: Multiplying Merged Cells

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.

# Betreff: Multiplying Merged Cells

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)

# Re: Multiplying Merged Cells

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

# Re: Multiplying Merged Cells

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)