SOLVED
Home

Condicional SI

%3CLINGO-SUB%20id%3D%22lingo-sub-658450%22%20slang%3D%22es-ES%22%3EConditional%20IF%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-658450%22%20slang%3D%22es-ES%22%3E%3CP%3EHello%20Good%20morning%2C%20how%20can%20I%20put%20a%20formula%20for%20me%20to%20add%20the%20number%20of%20numbers%20that%20are%20in%20a%20range%20of%20cells%2C%20but%20not%20the%20numbers%20that%20are%20in%20the%20cells%2C%20ie%20NOT%20what%20we%20would%20commonly%20do%20with%20the%20SUM%20formula%2C%20but%20only%20the%20amount%20of%20number%20there%3F%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-658450%22%20slang%3D%22es-ES%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-659217%22%20slang%3D%22en-US%22%3ERe%3A%20Condicional%20SI%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-659217%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F351962%22%20target%3D%22_blank%22%3E%40IsabelDBI%3C%2FA%3E%26nbsp%3B%2C%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIf%20I%20understood%20correctly%20that's%3C%2FP%3E%0A%3CPRE%3E%3DCOUNTA(B5%3AO5)%3C%2FPRE%3E%0A%3CP%3EPlease%20check%20formula%20for%20your%20locale%20in%20attached%20file%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-660887%22%20slang%3D%22es-ES%22%3ERe%3A%20Conditional%20IF%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-660887%22%20slang%3D%22es-ES%22%3EThank%20you.%3C%2FLINGO-BODY%3E
IsabelDBI
New Contributor

Hola buenos día, ¿cómo puedo poner una fórmula para que me sume la cantidad de números que hay en un rango de celdas, pero no los números que están en las celdas, es decir, NO lo que haríamos comúnmente con la fórmula SUMA, sino solo la cantidad de número que hay? 

 

 

2 Replies
Solution

@IsabelDBI ,

 

If I understood correctly that's

=COUNTA(B5:O5)

Please check formula for your locale in attached file

 

Gracias.
Related Conversations