{"id":14544,"date":"2020-03-25T09:42:00","date_gmt":"2020-03-25T09:42:00","guid":{"rendered":"https:\/\/www.perucontable.com\/excelcontable\/?p=14544"},"modified":"2023-11-20T22:48:41","modified_gmt":"2023-11-21T03:48:41","slug":"contar-y-sus-formulas-relacionadas-en-excel","status":"publish","type":"post","link":"https:\/\/www.perucontable.com\/excelcontable\/contar-y-sus-formulas-relacionadas-en-excel\/","title":{"rendered":"Contar y sus f\u00f3rmulas relacionadas en Excel"},"content":{"rendered":"\n<p>Usted estudiando, practicante y\nprofesional de la contabilidad sabemos por experiencia propia que en alg\u00fan\nmomento tenemos la necesidad de contar celdas con alg\u00fan criterio espec\u00edfico. <\/p>\n\n\n\n<p>Como su mismo nombre los dice, esta funci\u00f3n se encarga de contar la cantidad de celdas que contengan valores como n\u00fameros, fechas u otras representaciones textuales.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" loading=\"lazy\" width=\"197\" height=\"173\" src=\"https:\/\/www.perucontable.com\/excelcontable\/wp-content\/uploads\/2020\/03\/CONTAR1.jpg\" alt=\"\" class=\"wp-image-14546\"\/><\/figure>\n\n\n\n<p><strong>fx CONTAR<\/strong><\/p>\n\n\n\n<p>En esta funci\u00f3n solo podemos contar celdas que contengan n\u00fameros, las celdas vac\u00edas y las que su valor no sea n\u00fameros no las contara. <\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" loading=\"lazy\" width=\"273\" height=\"223\" src=\"https:\/\/www.perucontable.com\/excelcontable\/wp-content\/uploads\/2020\/03\/CONTAR3.jpg\" alt=\"\" class=\"wp-image-14547\"\/><\/figure>\n\n\n\n<p><strong>fx CONTARA<\/strong><\/p>\n\n\n\n<p>&nbsp;A diferencia de contar, esta funci\u00f3n cuenta cualquier valor que contenga las celdas.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" loading=\"lazy\" width=\"286\" height=\"217\" src=\"https:\/\/www.perucontable.com\/excelcontable\/wp-content\/uploads\/2020\/03\/contara.jpg\" alt=\"\" class=\"wp-image-14548\" srcset=\"https:\/\/www.perucontable.com\/excelcontable\/wp-content\/uploads\/2020\/03\/contara.jpg 286w, https:\/\/www.perucontable.com\/excelcontable\/wp-content\/uploads\/2020\/03\/contara-80x60.jpg 80w\" sizes=\"(max-width: 286px) 100vw, 286px\" \/><\/figure>\n\n\n\n<p><strong>fx CONTAR.BLANCO<\/strong><\/p>\n\n\n\n<p>Su nombre lo dice, esta funci\u00f3n contara las celdas que no contengan valores.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" loading=\"lazy\" width=\"310\" height=\"214\" src=\"https:\/\/www.perucontable.com\/excelcontable\/wp-content\/uploads\/2020\/03\/CONTARBLANCO.jpg\" alt=\"\" class=\"wp-image-14549\" srcset=\"https:\/\/www.perucontable.com\/excelcontable\/wp-content\/uploads\/2020\/03\/CONTARBLANCO.jpg 310w, https:\/\/www.perucontable.com\/excelcontable\/wp-content\/uploads\/2020\/03\/CONTARBLANCO-300x207.jpg 300w, https:\/\/www.perucontable.com\/excelcontable\/wp-content\/uploads\/2020\/03\/CONTARBLANCO-100x70.jpg 100w, https:\/\/www.perucontable.com\/excelcontable\/wp-content\/uploads\/2020\/03\/CONTARBLANCO-218x150.jpg 218w\" sizes=\"(max-width: 310px) 100vw, 310px\" \/><\/figure>\n\n\n\n<p><strong>fx CONTAR.SI<\/strong><\/p>\n\n\n\n<p>En esta funci\u00f3n contara valores que contengan un criterio espec\u00edfico.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" loading=\"lazy\" width=\"324\" height=\"201\" src=\"https:\/\/www.perucontable.com\/excelcontable\/wp-content\/uploads\/2020\/03\/CONTARSI.jpg\" alt=\"\" class=\"wp-image-14550\" srcset=\"https:\/\/www.perucontable.com\/excelcontable\/wp-content\/uploads\/2020\/03\/CONTARSI.jpg 324w, https:\/\/www.perucontable.com\/excelcontable\/wp-content\/uploads\/2020\/03\/CONTARSI-300x186.jpg 300w\" sizes=\"(max-width: 324px) 100vw, 324px\" \/><\/figure>\n\n\n\n<p>fx CONTAR.SI.CONJUNTO<\/p>\n\n\n\n<p>Esta funci\u00f3n se usa para contar valores que contengan m\u00e1s de un criterio.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" loading=\"lazy\" width=\"476\" height=\"217\" src=\"https:\/\/www.perucontable.com\/excelcontable\/wp-content\/uploads\/2020\/03\/CONTARCONJUNTO.jpg\" alt=\"\" class=\"wp-image-14551\" srcset=\"https:\/\/www.perucontable.com\/excelcontable\/wp-content\/uploads\/2020\/03\/CONTARCONJUNTO.jpg 476w, https:\/\/www.perucontable.com\/excelcontable\/wp-content\/uploads\/2020\/03\/CONTARCONJUNTO-300x137.jpg 300w\" sizes=\"(max-width: 476px) 100vw, 476px\" \/><\/figure>\n\n\n\n<p>Las m\u00faltiples funciones de contar no solo te sirve para contar como en los ejemplos ya brindados l\u00edneas arriba.<\/p>\n\n\n\n<p>Si estas interesado en saber m\u00e1s acerca de Excel d\u00e9janos tus sugerencias.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Usted estudiando, practicante y profesional de la contabilidad sabemos por experiencia propia que en alg\u00fan momento tenemos la necesidad de contar celdas con alg\u00fan criterio espec\u00edfico. Como su mismo nombre los dice, esta funci\u00f3n se encarga de contar la cantidad de celdas que contengan valores como n\u00fameros, fechas u otras representaciones textuales. fx CONTAR En [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":17649,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[67],"tags":[],"yst_prominent_words":[335,334,336,340,338,342,347,345,348,122,346,341,344,153,337,349,339,343],"_links":{"self":[{"href":"https:\/\/www.perucontable.com\/excelcontable\/wp-json\/wp\/v2\/posts\/14544"}],"collection":[{"href":"https:\/\/www.perucontable.com\/excelcontable\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.perucontable.com\/excelcontable\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.perucontable.com\/excelcontable\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.perucontable.com\/excelcontable\/wp-json\/wp\/v2\/comments?post=14544"}],"version-history":[{"count":4,"href":"https:\/\/www.perucontable.com\/excelcontable\/wp-json\/wp\/v2\/posts\/14544\/revisions"}],"predecessor-version":[{"id":16955,"href":"https:\/\/www.perucontable.com\/excelcontable\/wp-json\/wp\/v2\/posts\/14544\/revisions\/16955"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.perucontable.com\/excelcontable\/wp-json\/wp\/v2\/media\/17649"}],"wp:attachment":[{"href":"https:\/\/www.perucontable.com\/excelcontable\/wp-json\/wp\/v2\/media?parent=14544"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.perucontable.com\/excelcontable\/wp-json\/wp\/v2\/categories?post=14544"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.perucontable.com\/excelcontable\/wp-json\/wp\/v2\/tags?post=14544"},{"taxonomy":"yst_prominent_words","embeddable":true,"href":"https:\/\/www.perucontable.com\/excelcontable\/wp-json\/wp\/v2\/yst_prominent_words?post=14544"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}