Multiplying Merged Cells

%3CLINGO-SUB%20id%3D%22lingo-sub-1579906%22%20slang%3D%22en-US%22%3EMultiplying%20Merged%20Cells%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1579906%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20cells%20E%20and%20F%20merged%20into%20one%20cell%20and%20H%20and%20I%20merged%20into%201%20cell%2C%20and%20I%20want%20to%20multiply%20the%20numbers%20in%20each%20of%20those%20merged%20cells%20and%20used%20the%20folllowing%20command%20and%20it%20did%20not%20work%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3DSum%20E20*G20%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20also%20used%20parenthesis%20around%20the%20formula(E20*G20)%20also%20and%20still%20did%20not%20work.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20in%20advance%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1579906%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1580050%22%20slang%3D%22en-US%22%3ERe%3A%20Multiplying%20Merged%20Cells%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1580050%22%20slang%3D%22en-US%22%3Ealthough%20I%20don't%20like%20merged%20cells%2C%20that%20is%20for%20other%20reasons.%20You%20should%20be%20able%20to%20simply%20use%3A%3CBR%20%2F%3E%3DE20*G20%3CBR%20%2F%3EAt%20least%20it%20works%20for%20me.%20So%20if%20that%20doesn't%20work%20maybe%20there%20is%20something%20else%20going%20on.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1580414%22%20slang%3D%22de-DE%22%3ESubject%3A%20Multiplying%20Merged%20Cells%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1580414%22%20slang%3D%22de-DE%22%3EYour%20formula%20is%20OK%2C%20if%20you%20remove%20the%20word%20%22summe%22%20it%20will%20work.%20%3CBR%20%2F%3E%3CBR%20%2F%3E%20Word%20%22Sum%22%20away%20and%20the%20formula%20will%20be%20as%20mr%20mtarler%20suggested%20%3CLI-EMOJI%20id%3D%22lia_slightly-smiling-face%22%20title%3D%22%3Aslightly_smiling_face%3A%22%3E%3C%2FLI-EMOJI%3E%20%3CBR%20%2F%3E%3CBR%20%2F%3E%20Enjoy%20Excel%20%3CBR%20%2F%3E%3CBR%20%2F%3E%20Nikolino%20I%20%3CBR%20%2F%3E%20don't%20know%20anything%20(Socrates)%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1580593%22%20slang%3D%22en-US%22%3ERe%3A%20Multiplying%20Merged%20Cells%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1580593%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F755373%22%20target%3D%22_blank%22%3E%40Mowog%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EI%20guess%20if%20(%3CSPAN%3E%3CEM%3EE%20and%20F%20merged%3C%2FEM%3E)%20and%20(%3CEM%3EH%20and%20I%20merged%3C%2FEM%3E)%2C%20their%26nbsp%3Bmultiplication%20will%20be%20%3DE20*H20%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1580613%22%20slang%3D%22de-DE%22%3ERe%3A%20Multiplying%20Merged%20Cells%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1580613%22%20slang%3D%22de-DE%22%3EI'm%20not%20sure%20if%20that's%20what%20the%20cells%20mean.%20The%20expression%20%22would%20like%20to%20multiply%20the%20numbers%20in%20each%20of%20these%20merged%20cells%22%20refers%20to%20the%20%22cells%20E%20and%20F%20to%20one%20cell%20and%20H%20and%20I%22%20or%20to%20the%20previous%20composition%20of%20the%20user%3F%20%3CBR%20%2F%3E%3CBR%20%2F%3E%20The%20user%20has%20to%20explain%20that%20to%20us.%20%3CBR%20%2F%3E%20Better%20description%20(even%20better%20with%20one%20file)%2C%20better%20solution.%20%3CBR%20%2F%3E%3CBR%20%2F%3E%20Nikolino%20%3CBR%20%2F%3E%20I%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FLINGO-BODY%3E
Occasional Visitor

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

@Mowog 

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)