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
Highlighted
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
Highlighted

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

Highlighted
Highlighted

@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)