{"id":8462,"date":"2018-11-12T10:52:42","date_gmt":"2018-11-12T10:52:42","guid":{"rendered":"http:\/\/www.nurturetechacademy.in\/?p=8462"},"modified":"2018-11-13T09:31:16","modified_gmt":"2018-11-13T09:31:16","slug":"count-functions-ms-excel-2","status":"publish","type":"post","link":"https:\/\/www.nurturetechacademy.in\/dev.nurturetechacademy.in\/count-functions-ms-excel-2\/","title":{"rendered":"Count Functions in MS Excel"},"content":{"rendered":"

The requirement of counting is almost always present in our day to day job and Excel made it really easy for us by giving a number of counting functions like Count, CountA, CountBlank, CountIf and CountIfs. Let\u2019s understand them in detail one by one:<\/p>\n

\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 1.\u00a0COUNT FUNCTION-<\/u><\/strong>\u00a0COUNT function count only those cells which have only numerical values.<\/p>\n

\"Pic-1\"<\/p>\n

How to Apply COUNT?<\/u><\/strong><\/p>\n

As per the screenshot above, one\u00a0need\u00a0to count the total number of payments received.<\/p>\n

Syntax- =Count(Value1,Value2\u2026\u2026\u2026)<\/p>\n

Arguments<\/u><\/strong><\/p>\n

Value1- [Mendatory Argument] We can choose a single cell or can select the whole range<\/p>\n

Value2- [Optional Argument] We can choose a single cell or can select the whole range<\/p>\n

\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 2.\u00a0COUNTA<\/u><\/strong>\u00a0\u2013 It can count all the occupied cells in the selection.<\/p>\n

\"Pic-2\"<\/p>\n

Arguments are same as mentioned in \u201cCount Function above\u201d.<\/em><\/p>\n

\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 3.\u00a0COUNTBLANK-\u00a0<\/u><\/strong>This can count all the blank cells in the selection.<\/p>\n

\"Pic-3\"<\/p>\n

How to Apply CountBlank?<\/u><\/strong><\/p>\n

Syntax-<\/p>\n

=COUNTBLANK(RANGE)<\/p>\n

Arguments-<\/u><\/strong><\/p>\n

Range- Range is a set of cells from where you want to count the Blank Cells.<\/p>\n

\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 4.\u00a0COUNTIF<\/u><\/strong>– It Can count those cells which match a specific condition in our selection of cells.<\/p>\n

Syntax –<\/p>\n

=COUNTIF(range,Criteria)<\/p>\n

Range- Range is a set of cells which needs to be counted based on criteria.<\/p>\n

Criteria- Criteria is the condition in the form of number, expression, or text that defines which cells will get counted.<\/p>\n

\"Pic-4\"<\/p>\n

The Formula =COUNTIF (B2: B10,\u201d Saving\u201d) counts how many times \u201cSaving\u201d is on the list. This will help us know how many saving accounts are present in this branch.<\/p>\n

Note:\u00a0 A criterion is not case sensitive.<\/em><\/p>\n

\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 5.\u00a0COUNTIFS-<\/u><\/strong>\u00a0It can count cells based on multiple conditions\/criteria.<\/p>\n

Syntax \u2013<\/p>\n

=COUNTIFS(criteria_range1, crietria1, [criteria_range2, criteria2], \u2026\u2026)<\/p>\n

Criteria_range1-<\/u><\/strong>\u00a0defines the first range to which the first condition (criteria1) shall be applied.<\/p>\n

Criteria1-<\/u><\/strong>\u00a0sets the condition in the form of a number, cell reference, text string, expression or another Excel function, required. The criteria define which cells shall be counted.<\/p>\n

([Criteria_range2],[Criteria2],[Criteria_range3],[Criteria3]\u2026\u2026.)<\/strong>\u00a0theses are additional ranges and their criteria\u2019s are optional. You can specify 127 criteria at one time in COUNTIFS Function.<\/p>\n

\"pic-5\"<\/p>\n

In this screenshot, we want to count a Total number of \u201cCurrent accounts\u201d opened with amount more than >500000. we have two criteria\u2019s :<\/p>\n\n\n\n
=COUNTIFS(B2:B20,”Current”,C2:C20,”>500000″)<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

In fact, no need to remember the syntax of any function in Excel as the moment one opens up any function, Excel will display the function’s complete syntax, as soon as you start typing; the argument you are entering now is highlighted in bold.<\/p>\n

Refer the screenshot below:<\/p>\n

\"Pic-7\"<\/p>\n

Happy Learning\u00a0\ud83d\ude0a<\/p>\n

<\/div>\n

<\/path><\/svg><\/i> \"Loading\"<\/p>\n

<\/div>\n","protected":false},"excerpt":{"rendered":"

The requirement of counting is almost always present in our day to day job and Excel made it really easy for us by giving a number of counting functions like Count, CountA, CountBlank, CountIf and CountIfs. Let\u2019s understand them in <\/p>\n

<\/div>\n

<\/path><\/svg><\/i> \"Loading\"<\/p>\n

<\/div>\n","protected":false},"author":1,"featured_media":8465,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0,"footnotes":""},"categories":[56],"tags":[265,266,263,243,264,316,317,319,318,325,323,324,326,328,327,257,260,259,249,256,248,321,322,320,244,250,252,245,253,254,246,251,267,255,262,258,247,261],"class_list":["post-8462","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel","tag-corporate-training-companies","tag-corporate-training-companies-in-delhi","tag-corporate-training-courses","tag-corporate-training-in-delhi","tag-corporate-training-programs","tag-count-function","tag-count-function-in-excel","tag-count-function-in-microsoft-excel","tag-count-function-in-ms-excel","tag-count-if","tag-count-if-in-excel","tag-count-if-in-ms-office","tag-counta","tag-countblank","tag-countifs","tag-excel-course-online","tag-excel-courses-online","tag-excel-online-course","tag-excel-online-training","tag-excel-training-in-delhi","tag-excel-training-online","tag-how-to-use-count-function-in-excel","tag-how-to-use-count-function-in-microsoft-excel","tag-how-to-use-count-function-in-ms-excel","tag-learn-microsoft-excel","tag-learn-ms-excel-online","tag-learning-excel-online","tag-learning-microsoft-excel","tag-microsoft-excel-course","tag-microsoft-excel-online-training","tag-microsoft-excel-training","tag-ms-excel-learning","tag-ms-excel-online-training","tag-ms-excel-training-in-delhi","tag-online-corporate-training","tag-online-excel-course","tag-online-excel-training","tag-online-excel-training-courses"],"_links":{"self":[{"href":"https:\/\/www.nurturetechacademy.in\/dev.nurturetechacademy.in\/wp-json\/wp\/v2\/posts\/8462","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.nurturetechacademy.in\/dev.nurturetechacademy.in\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.nurturetechacademy.in\/dev.nurturetechacademy.in\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.nurturetechacademy.in\/dev.nurturetechacademy.in\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.nurturetechacademy.in\/dev.nurturetechacademy.in\/wp-json\/wp\/v2\/comments?post=8462"}],"version-history":[{"count":2,"href":"https:\/\/www.nurturetechacademy.in\/dev.nurturetechacademy.in\/wp-json\/wp\/v2\/posts\/8462\/revisions"}],"predecessor-version":[{"id":8464,"href":"https:\/\/www.nurturetechacademy.in\/dev.nurturetechacademy.in\/wp-json\/wp\/v2\/posts\/8462\/revisions\/8464"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.nurturetechacademy.in\/dev.nurturetechacademy.in\/wp-json\/wp\/v2\/media\/8465"}],"wp:attachment":[{"href":"https:\/\/www.nurturetechacademy.in\/dev.nurturetechacademy.in\/wp-json\/wp\/v2\/media?parent=8462"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.nurturetechacademy.in\/dev.nurturetechacademy.in\/wp-json\/wp\/v2\/categories?post=8462"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.nurturetechacademy.in\/dev.nurturetechacademy.in\/wp-json\/wp\/v2\/tags?post=8462"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}