{"id":12106,"date":"2011-12-16T18:19:23","date_gmt":"2011-12-16T18:19:23","guid":{"rendered":"http:\/\/www.learnexcelmacro.com\/?p=1023"},"modified":"2011-12-16T18:19:23","modified_gmt":"2011-12-16T18:19:23","slug":"count-function-and-counta-function","status":"publish","type":"post","link":"https:\/\/vmlogger.com\/excel\/2011\/12\/count-function-and-counta-function\/","title":{"rendered":"COUNT and COUNTA Function"},"content":{"rendered":"
COUNT is a Excel inbuilt formula. It takes CELL RANGE<\/strong> as an input and give the total count of the Cells which are having Numeric Values. Note:<\/strong> If you want to count all the cell number which are NOT EMPTY; no matter what value they have, then you can use COUNTA()<\/strong> function. COUNTA is a Excel inbuilt formula similar to COUNT. The only major difference is that it returns the total number of Cells which are not EMPTY no matter what value, they are holding.<\/p>\n Syntax:<\/strong> =COUNTA(Cell Range) COUNT(): COUNT is a Excel inbuilt formula. It takes CELL RANGE as an input and give the total count of the Cells which are having Numeric Values. Important: COUNT counts only those cells which are having “Numeric” Values. It ignores those cell which are having non-numeric values. Syntax: =COUNT(Cell Range) Input Parameter: Cell or Cell […]<\/p>\n","protected":false},"author":45,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_et_pb_use_builder":"","_et_pb_old_content":"","_et_gb_content_width":"","footnotes":""},"categories":[1673],"tags":[],"class_list":["post-12106","post","type-post","status-publish","format-standard","hentry","category-excel-functions"],"yoast_head":"\n
\nImportant:<\/strong> COUNT counts only those cells which are having “Numeric” Values. It ignores those cell which are having non-numeric values.
\nSyntax:<\/strong> =COUNT(Cell Range)
\nInput Parameter:<\/strong> Cell or Cell Range (“A1:B2”) or (“A1”)
\nOutput:<\/strong> Number of Cell which are having only Numeric values<\/strong><\/p>\n
\n<\/p>\nCOUNTA():<\/h2>\n
\nInput Parameter:<\/strong> Cell or Cell Range (“A1:B2”) or (“A1”)
\nOutput:<\/strong> Number of Cell which are NOT EMPTY<\/strong>
<\/p>\n<\/span>","protected":false},"excerpt":{"rendered":"