Home

Formula excel

%3CLINGO-SUB%20id%3D%22lingo-sub-1125357%22%20slang%3D%22es-ES%22%3EFormula%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1125357%22%20slang%3D%22es-ES%22%3E%3CP%3EGood%20morning%2C%20is%20there%20a%20formula%20in%20excel%20to%20find%20a%20certain%20sum%3F%20example%2C%20I%20have%2020%20different%20amounts%20and%20I%20want%20to%20find%20out%20which%20of%20those%20give%20me%20a%20certain%20sum.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%2020%2C%20000%20I%20want%20to%20know%20how%20many%20amounts%20adding%20them%20give%20me%20that%20result%3A%26nbsp%3B%3C%2FP%3E%3CP%3E5%2C000%2B6%2C000%2B4%2C000%2B8%2C000%2B9%2C000%2B7%2C000%2B18%2C000%2B100%3C%2FP%3E%3CP%3EIn%20this%20iknow%20the%20sum%20would%20be%20serious%3A%205%2C000%2B6%2C000%2B9%2C000%2C%20the%20problem%20is%20when%20I%20have%20decimals.%3C%2FP%3E%3CP%3EI%20hope%20you%20can%20help%20me.%3C%2FP%3E%3CP%3EBest%20regards.%3C%2FP%3E%3CP%3EThank%20you.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1125357%22%20slang%3D%22es-ES%22%3E%3CLINGO-LABEL%3EEducation%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMicrosoft%20Teams%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
Occasional Visitor

Buen dia, existe una fórmula en excel para encontrar una determinada suma? ejemplo, tengo 20 cantidades diferentes y quiero encontrar cuales de esas me dan una suma determinada.

 

Tengo 20,000 quiero saber cuales cantidades sumandolas me dan ese resultado: 

5,000+6,000+4,000+8,000+9,000+7,000+18,000+100

En este se que la suma seria: 5,000+6,000+9,000, el problema es cuando tengo decimales.

Espero me puedan ayudar.

Saludos.

Gracias.

 

Related Conversations
Excel
Chris246 in Excel on
2 Replies
How to compare groups in multiple regression?
jhmarshall86 in Excel on
0 Replies
DIFFERENCE
Aijasne in Excel on
1 Replies
Auto Populate most recent date from list to another list
Tulyy in Excel on
0 Replies
Fonction si
ouissem in Excel on
0 Replies