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
Extentions Synchronization
Deleted in Discussions on
3 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
35 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
9 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies