ayuda con Excel

%3CLINGO-SUB%20id%3D%22lingo-sub-1602828%22%20slang%3D%22es-ES%22%3Ehelp%20with%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1602828%22%20slang%3D%22es-ES%22%3E%3CP%3EGood%20I%20need%20to%20know%20which%20formula%20I%20apply%20to%20a%20table%20where%20I%20have%20several%20numbers%20and%20I%20need%20the%20summation%20not%20to%20double%20the%20numbers%20depending%20on%20what%20I%20require%3A%20axis%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E9117-6%3C%2FP%3E%3CP%3E9117-6%3C%2FP%3E%3CP%3E9117-6%3C%2FP%3E%3CP%3E9118-148%3C%2FP%3E%3CP%3E9118-50%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ein%20the%20case%20of%20numbers%20that%20have%20the%20same%20on%20both%20sides%20I%20just%20need%20to%20post%20one%3C%2FP%3E%3CP%3Ein%20case%20they%20have%20the%20same%20as%20on%20the%20left%20but%20different%20to%20the%20right%20than%20the%20normal%20sume%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1602828%22%20slang%3D%22es-ES%22%3E%3CLINGO-LABEL%3EFormulas%20and%20functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1603122%22%20slang%3D%22en-US%22%3ERe%3A%20ayuda%20con%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1603122%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F766424%22%20target%3D%22_blank%22%3E%40CrisRo700%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EDear%20Mr.%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F766424%22%20target%3D%22_blank%22%3E%40CrisRo700%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20cannot%20make%20much%20sense%20of%20the%20translation%3C%2FP%3E%3CP%3Ebut%20I%20understood%20you%20needed%20the%20summation%20of%20the%20digits%20if%20the%20numbers%20are%20unique%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eanyways%20you%20can%20do%20it%20as%20in%20the%20Excel%20File%20attached%3C%2FP%3E%3CP%3Ebest%20of%20luck%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1603813%22%20slang%3D%22es-ES%22%3ERe%3A%20Excel%20help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1603813%22%20slang%3D%22es-ES%22%3E%3CP%3EThank%20you%20very%20much%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F746148%22%20target%3D%22_blank%22%3E%40ramizassaf%3C%2FA%3E%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20regret%20the%20bad%20translation%2C%20what%20I%20require%20is%20that%20it%20is%20counted%20only%20once%20in%20case%20the%20row%20on%20the%20right%20and%20the%20left%20is%20repeated%2C%20not%20added%20up%20if%20not%20an%20example%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CTABLE%20width%3D%22320%22%3E%3CTBODY%3E%3CTR%3E%3CTD%20width%3D%2280%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2280%22%3E9115%3C%2FTD%3E%3CTD%20width%3D%2280%22%3E4%3C%2FTD%3E%3CTD%20width%3D%2280%22%3Esum%201%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2280%22%3E9115%3C%2FTD%3E%3CTD%20width%3D%2280%22%3E4%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2280%22%3E9115%3C%2FTD%3E%3CTD%20width%3D%2280%22%3E7%3C%2FTD%3E%3CTD%3Esum%201%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2280%22%3E9115%3C%2FTD%3E%3CTD%20width%3D%2280%22%3E8%3C%2FTD%3E%3CTD%3Esum%201%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2280%22%3E9115%3C%2FTD%3E%3CTD%20width%3D%2280%22%3E21%3C%2FTD%3E%3CTD%3Esum%201%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3ETotal%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E4%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBut%20let%20him%20do%20it%20automatic%2C%20not%20me%20adding%20one%20by%20one%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1605333%22%20slang%3D%22en-US%22%3ERe%3A%20ayuda%20con%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1605333%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F766424%22%20target%3D%22_blank%22%3E%40CrisRo700%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20find%20the%20solution%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1608346%22%20slang%3D%22es-ES%22%3ERe%3A%20Excel%20help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1608346%22%20slang%3D%22es-ES%22%3EThank%20you%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

Buenas necesito saber cuál formula aplico a una tabla donde tengo varios números y necesito que la sumatoria no me duplique los numeros dependiendo lo que requiero: eje

 

9117-6

9117-6

9117-6

9118-148

9118-50

 

en el caso de los numeros que tienen el mismo en ambos lados necesito solo contabilice uno

en e caso de que tengan igual el de la izquierda pero diferente a la derecha que los sume normal 

4 Replies
Highlighted

@CrisRo700 

 

Dear Mr. @CrisRo700 

 

I cannot make much sense of the translation

but I understood you needed the summation of the digits if the numbers are unique

 

anyways you can do it as in the Excel File attached

best of luck

Highlighted

Muchas gracias@Ramiz_Assaf,

 

lamento la mala traducción, lo que requiero es que se contabilice solo una vez en caso de que se repitan a tanto la fila de la derecha como la izquierda no que lo sume si no ejemplo:

 

 91154suma 1
 91154 
 91157suma 1
 91158suma 1
 911521suma 1
    
Total  4 

 

 

Pero que lo haga automático, no yo sumando uno por uno

Highlighted

@CrisRo700 

Please find the solution

Highlighted
gracias