Home

En la fórmula de suma me dice que tengo un límite de celdas que puedo sumas (unas 35)

%3CLINGO-SUB%20id%3D%22lingo-sub-875563%22%20slang%3D%22en-US%22%3ERe%3A%20En%20la%20f%C3%B3rmula%20de%20suma%20me%20dice%20que%20tengo%20un%20l%C3%ADmite%20de%20celdas%20que%20puedo%20sumas%20(unas%2035)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-875563%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F415159%22%20target%3D%22_blank%22%3E%40gonza2710x%3C%2FA%3E%26nbsp%3Bbetter%20if%20you%20submit%20small%20sample%20file%20to%20show%20how%20do%20you%20use%20SUM%2C%20it's%20not%20what%20is%20an%20issue.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-875020%22%20slang%3D%22es-ES%22%3EIn%20the%20sum%20formula%20tells%20me%20that%20I%20have%20a%20limit%20of%20cells%20that%20I%20can%20sum%20(about%2035)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-875020%22%20slang%3D%22es-ES%22%3E%3CP%3EHello%20everyone.%20In%20the%20sum%20formula%20I%20can%20only%20add%20about%2035%20cells%20and%20then%20he%20won't%20let%20me%20keep%20adding%20cells.%20How%20do%20I%20get%20him%20to%20let%20me%20add%20more%20cells%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-875020%22%20slang%3D%22es-ES%22%3E%3CLINGO-LABEL%3EHelp%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESum%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-876686%22%20slang%3D%22es-ES%22%3ERe%3A%20In%20the%20sum%20formula%20tells%20me%20that%20I%20have%20a%20limit%20of%20cells%20that%20I%20can%20sum%20(about%2035)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-876686%22%20slang%3D%22es-ES%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%20I've%20submitted%20a%20small%20sample%20file%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-876693%22%20slang%3D%22en-US%22%3ERe%3A%20En%20la%20f%C3%B3rmula%20de%20suma%20me%20dice%20que%20tengo%20un%20l%C3%ADmite%20de%20celdas%20que%20puedo%20sumas%20(unas%2035)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-876693%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F415159%22%20target%3D%22_blank%22%3E%40gonza2710x%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIf%20I%20understood%20correctly%20the%20message%20on%20the%20picture%2C%20it%20says%20you%20entered%20more%20arguments%20than%20supported.%20For%20Excel%202003%20max%20number%20of%20arguments%20in%20SUM%20is%2030%2C%20for%20later%20versions%20256.%20You%20may%20simplify%20your%20formula%20like%3C%2FP%3E%0A%3CPRE%20class%3D%22lia-code-sample%20language-markup%22%3E%3CCODE%3E%3DSUMA(A40%3BD40%3AD53%3BF40%3AF56)%3C%2FCODE%3E%3C%2FPRE%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
gonza2710x
New Contributor

Hola a todos. En la fórmula de suma sólo puedo sumar unas 35 celdas y luego no me deja seguir sumando celdas. ¿Cómo hago para que me deje sumar más celdas?

3 Replies

@gonza2710x better if you submit small sample file to show how do you use SUM, it's not what is an issue.

@gonza2710x 

If I understood correctly the message on the picture, it says you entered more arguments than supported. For Excel 2003 max number of arguments in SUM is 30, for later versions 256. You may simplify your formula like

=SUMA(A40;D40:D53;F40:F56)

 

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies