Summenprodukt/Summe

%3CLINGO-SUB%20id%3D%22lingo-sub-2777567%22%20slang%3D%22de-DE%22%3ETotal%20Product%2FSum%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2777567%22%20slang%3D%22de-DE%22%3EHello%2C%20can%20someone%20help%20me%20fix%20my%20error%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2777567%22%20slang%3D%22de-DE%22%3E%3CLINGO-LABEL%3EExcel%20for%20web%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20on%20Mac%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2777639%22%20slang%3D%22en-US%22%3ERe%3A%20Summenprodukt%2FSumme%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2777639%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1164311%22%20target%3D%22_blank%22%3E%40finnerdmann123%3C%2FA%3E%26nbsp%3BWhy%20use%20SUMPRODUCT%3F%20Try%20%3CSTRONG%3E%3D(G14%2BG18%2BG39)%20%2F%20C40%3C%2FSTRONG%3E%20.%20But%20perhaps%20I%20misunderstand%20your%20intentions.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor
Hallo, kann mir jemand helfen meinen Fehler zu beheben
2 Replies

@finnerdmann123 

SUMMENPRODUKT() funktioniert so nicht. Einfachste Lösung ist eine Hilfsspalte.

@finnerdmann123 

SUMMENPRODUKT funktioniert nicht mit Bereichen die aus einzelnen Zellen bestehen.
Verwenden Sie =(C14*G14+C18*G18+C39*G39)/(C14+C18+C39)