Teile der Summe finden

%3CLINGO-SUB%20id%3D%22lingo-sub-1415522%22%20slang%3D%22de-DE%22%3EFind%20parts%20of%20the%20sum%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1415522%22%20slang%3D%22de-DE%22%3E%3CP%3EGood%20morning%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eis%20there%20a%20formula%20where%20you%20can%20recognize%20the%20parts%20of%20a%20sum%3F%20In%20other%20words%2C%20the%20sum%20is%20already%20known%20and%20the%20components%20of%20a%20long%20list%20of%20numbers%20are%20to%20be%20displayed.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1415522%22%20slang%3D%22de-DE%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1415527%22%20slang%3D%22en-US%22%3ERE%3A%20Teile%20der%20Summe%20finden%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1415527%22%20slang%3D%22en-US%22%3E%3CP%3EHallo%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EK%C3%B6nnen%20Sie%20einige%20Beispiele%20geben%3F%26nbsp%3BWelche%20Excel%20Version%20haben%20Sie%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EGru%C3%9F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1415545%22%20slang%3D%22de-DE%22%3ERE%3A%20Find%20parts%20of%20the%20sum%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1415545%22%20slang%3D%22de-DE%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F676180%22%20target%3D%22_blank%22%3E%40Jos_Woolley%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIt's%20about%20Excel%20365.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EE.g.%3A%20I%20have%20the%20sum%20of%201808%20%E2%82%AC%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENumbers%20from%201000%2C%205000%2C%20800%2C%20400%2C%2010%2C%208%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eand%20want%20a%20formula%20that%20has%20the%20components%20of%20my%20sum.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1415556%22%20slang%3D%22en-US%22%3ERE%3A%20Teile%20der%20Summe%20finden%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1415556%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F678676%22%20target%3D%22_blank%22%3E%40Marie_D2285%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks.%20What's%20the%20%3CSTRONG%3Emaximum%3C%2FSTRONG%3E%20number%20of%20entries%20to%20consider%20for%20making%20the%20sum%3F%20In%20your%20example%20there%20are%206%20(1000%2C%205000%2C%20800%2C%20400%2C%2010%20and%208).%20Will%20it%20ever%20be%20much%20more%20than%20this%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERegards%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1415572%22%20slang%3D%22de-DE%22%3ERE%3A%20Find%20parts%20of%20the%20sum%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1415572%22%20slang%3D%22de-DE%22%3Eit's%20more%20about%2060%20-%20100%20entries.%20%3CBR%20%2F%3E%3CBR%20%2F%3E%20Greeting%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1415598%22%20slang%3D%22en-US%22%3ERE%3A%20Teile%20der%20Summe%20finden%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1415598%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F678676%22%20target%3D%22_blank%22%3E%40Marie_D2285%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20that%20case%20there%20will%20be%20more%20than%26nbsp%3B%3CSTRONG%3E1%2C000%2C000%2C000%2C000%2C000%2C000%3C%2FSTRONG%3E%20(one%20%3CSTRONG%3Equintillion%3C%2FSTRONG%3E)%20possibilities%20to%20consider.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAs%20such%2C%20unless%20there%20are%20some%20criteria%20which%20can%20be%20applied%20to%20vastly%20reduce%20the%20number%20of%20combinations%20to%20consider%2C%20this%20will%20certainly%20not%20be%20possible%20using%20Excel%20formulas.%20Even%20with%20VBA%20you%20will%20be%20looking%20at%20potentially%20enormous%20computation%20times.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERegards%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1415684%22%20slang%3D%22en-US%22%3ERE%3A%20Teile%20der%20Summe%20finden%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1415684%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F678676%22%20target%3D%22_blank%22%3E%40Marie_D2285%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20could%20try%20one%20of%20the%20VBA%20solutions%20posted%20%3CA%20href%3D%22https%3A%2F%2Fwww.mrexcel.com%2Fchallenges%2Faccounts-receivable-challenge%2F%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehere%3C%2FA%3E.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERegards%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1415786%22%20slang%3D%22de-DE%22%3ERE%3A%20Find%20parts%20of%20the%20sum%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1415786%22%20slang%3D%22de-DE%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F676180%22%20target%3D%22_blank%22%3E%40Jos_Woolley%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20see.%20Thank%20you%20very%20much.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHave%20a%20good%20day!%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

Guten Morgen,

 

gibt es einen Formel, bei welcher man die Teile einer Summe erkennen kann? Sprich die Summe ist bereits bekannt und es sollen nun die Komponenten einer langen Liste an Zahlen angezeigt werden.

 

6 Replies
Highlighted

Hallo,

 

Können Sie einige Beispiele geben? Welche Excel Version haben Sie?

 

Gruß

Highlighted

@Jos_Woolley 

 

Es geht um Excel 365.

 

Z.B.: ich habe die Summe von 1808 €

 

Zahlen von 1000, 5000, 800, 400, 10, 8

 

und möchte eine Formel, welche mir die Bestandteile meiner Summe aufweist. 

Highlighted

@Marie_D2285 

 

Thanks. What's the maximum number of entries to consider for making the sum? In your example there are 6 (1000, 5000, 800, 400, 10 and 8). Will it ever be much more than this?

 

Regards

Highlighted
es geht hier eher um 60 - 100 Einträge.

Gruß
Highlighted

@Marie_D2285 

 

In that case there will be more than 1,000,000,000,000,000,000 (one quintillion) possibilities to consider.

 

As such, unless there are some criteria which can be applied to vastly reduce the number of combinations to consider, this will certainly not be possible using Excel formulas. Even with VBA you will be looking at potentially enormous computation times.

 

Regards

Highlighted

@Jos_Woolley 

 

I see. Thank you very much.

 

Have a good day!