{"id":148,"date":"2019-04-02T12:31:56","date_gmt":"2019-04-02T09:31:56","guid":{"rendered":"https:\/\/www.test4u.eu\/excelpedia\/?p=148"},"modified":"2019-04-04T16:24:07","modified_gmt":"2019-04-04T13:24:07","slug":"the-count-function","status":"publish","type":"post","link":"https:\/\/www.test4u.eu\/excelpedia\/the-count-function\/","title":{"rendered":"The COUNT function"},"content":{"rendered":"\n<p>The <strong>COUNT <\/strong>function provides us with a way to count the number of cells that contain numbers. <\/p>\n\n\n\n<p>This is the syntax of the function:<\/p>\n\n\n\n<blockquote class=\"wp-block-quote is-style-large is-layout-flow wp-block-quote-is-layout-flow\"><p><strong>COUNT(v1, [v2])<\/strong><\/p><cite><strong>v1<\/strong>, <strong>v2, &#8230; <\/strong>: They are the cell references or cell ranges within which you want to count numbers.  <br> <strong>v2, &#8230;<\/strong> : Optional  arguments that can be up to a maximum of 255 <br><\/cite><\/blockquote>\n\n\n\n<p><\/p>\n\n\n\n<p>COUNT only counts <strong>number <\/strong>values. It doesn&#8217;t count:<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Logical values<\/li><li>Text values<\/li><li>Error values<\/li><li>Empty cells<\/li><\/ul>\n\n\n\n<p>If you want to include the above in the count then you have to use the function <strong><a href=\"https:\/\/www.test4u.eu\/excelpedia\/the-counta-function\/\" target=\"_blank\" rel=\"noreferrer noopener\" aria-label=\"COUNTA (opens in a new tab)\">COUNTA<\/a>.<\/strong><\/p>\n\n\n\n\n<div style=\"height:50px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p>Click on the button to practice using this function, with the help of our <strong>Online Assessment Tool<\/strong>:<\/p>\n\n\n<p class=\"button-practice-container\" ><a class=\"button button-primary button-practice\" style=\"height:auto\"  href=\"https:\/\/www.test4u.eu\/excelpedia\/wp-content\/plugins\/unlimited-integration\/run.php?id=eGRZdm11bXFRZWlnQnhZWXdoWkRXYWxsVTh3SCtGL2thMjVpMXZlVDJYb1V5cVpaanBXaGtUWnFLcjZyWmFIRQ==&b=bUV5b0I2dzRVL0FLMGIxbmdtUVVzZFZNS0RJZkJyZ3NqNlRtZnBTMGU0UGdidi9JMjVFUE9DUlN1dE5vajNjMkFxd0l3NThlUHJxNzlBcGd1cmJ5ZUhQM05zTzIzRkpmeHVBeHFCbEkrVkE9\">Practice<\/a><\/p>\n\n\n\n<div style=\"height:50px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n\n<p class=\"has-medium-font-size\"><strong>Here are some video examples of possible uses of COUNT: <\/strong><\/p>\n\n\n\n<p><\/p>\n\n\n\n<p> In the cell <strong>B1 <\/strong>of the <strong>Total <\/strong>worksheet insert the appropriate function to sum up the cells within the cell range <strong>A1:A10<\/strong> from the <strong>FF1 <\/strong>worksheet through to the <strong>FF12 <\/strong>worksheet.<br> Insert in the cell <strong>B2 <\/strong>a function that returns the average of the respective cell range, in cell <strong>B3 <\/strong>for the minimum, in cell <strong>B4 <\/strong>for the maximum and in cell <strong>B5 <\/strong>for the total of cells displaying numbers, following the same pattern. <\/p>\n\n\n\n<figure class=\"wp-block-embed-youtube wp-block-embed is-type-video is-provider-youtube wp-embed-aspect-4-3 wp-has-aspect-ratio\"><div class=\"wp-block-embed__wrapper\">\n<span class=\"embed-youtube\" style=\"text-align:center; display: block;\"><iframe class=\"youtube-player\" width=\"640\" height=\"360\" src=\"https:\/\/www.youtube.com\/embed\/IRNzb5Z8i8Q?version=3&#038;rel=0&#038;showsearch=0&#038;showinfo=1&#038;iv_load_policy=1&#038;fs=1&#038;hl=en-US&#038;autohide=2&#038;wmode=transparent\" allowfullscreen=\"true\" style=\"border:0;\" sandbox=\"allow-scripts allow-same-origin allow-popups allow-presentation allow-popups-to-escape-sandbox\"><\/iframe><\/span>\n<\/div><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<p>Insert in the cell <strong>C116<\/strong> a function to count the total of cells containing numbers within the cell range <strong>C3:C110<\/strong>.<\/p>\n\n\n\n<figure class=\"wp-block-embed-youtube wp-block-embed is-type-video is-provider-youtube wp-embed-aspect-4-3 wp-has-aspect-ratio\"><div class=\"wp-block-embed__wrapper\">\n<span class=\"embed-youtube\" style=\"text-align:center; display: block;\"><iframe class=\"youtube-player\" width=\"640\" height=\"360\" src=\"https:\/\/www.youtube.com\/embed\/w592gHhgsTU?version=3&#038;rel=0&#038;showsearch=0&#038;showinfo=1&#038;iv_load_policy=1&#038;fs=1&#038;hl=en-US&#038;autohide=2&#038;wmode=transparent\" allowfullscreen=\"true\" style=\"border:0;\" sandbox=\"allow-scripts allow-same-origin allow-popups allow-presentation allow-popups-to-escape-sandbox\"><\/iframe><\/span>\n<\/div><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<p>Navigate to the cell <strong>A8<\/strong> and use the appropriate function to display the total of the cells displaying numbers within the cell range <strong>A1:A6<\/strong>.<\/p>\n\n\n\n<figure class=\"wp-block-embed-youtube wp-block-embed is-type-video is-provider-youtube wp-embed-aspect-4-3 wp-has-aspect-ratio\"><div class=\"wp-block-embed__wrapper\">\n<span class=\"embed-youtube\" style=\"text-align:center; display: block;\"><iframe class=\"youtube-player\" width=\"640\" height=\"360\" src=\"https:\/\/www.youtube.com\/embed\/q2lHhXdlKw0?version=3&#038;rel=0&#038;showsearch=0&#038;showinfo=1&#038;iv_load_policy=1&#038;fs=1&#038;hl=en-US&#038;autohide=2&#038;wmode=transparent\" allowfullscreen=\"true\" style=\"border:0;\" sandbox=\"allow-scripts allow-same-origin allow-popups allow-presentation allow-popups-to-escape-sandbox\"><\/iframe><\/span>\n<\/div><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<p>Navigate to the cell <strong>E11<\/strong> and display the total of the cells displaying numbers in the cell range <strong>E6:E9<\/strong>.<\/p>\n\n\n\n<figure class=\"wp-block-embed-youtube wp-block-embed is-type-video is-provider-youtube wp-embed-aspect-4-3 wp-has-aspect-ratio\"><div class=\"wp-block-embed__wrapper\">\n<span class=\"embed-youtube\" style=\"text-align:center; display: block;\"><iframe class=\"youtube-player\" width=\"640\" height=\"360\" src=\"https:\/\/www.youtube.com\/embed\/PTmylNxEbbs?version=3&#038;rel=0&#038;showsearch=0&#038;showinfo=1&#038;iv_load_policy=1&#038;fs=1&#038;hl=en-US&#038;autohide=2&#038;wmode=transparent\" allowfullscreen=\"true\" style=\"border:0;\" sandbox=\"allow-scripts allow-same-origin allow-popups allow-presentation allow-popups-to-escape-sandbox\"><\/iframe><\/span>\n<\/div><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>The COUNT function provides us with a way to count the number of cells that contain numbers. <\/p>\n","protected":false},"author":2,"featured_media":164,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[4],"tags":[13,14],"class_list":["post-148","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-functions","tag-count","tag-statistical"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"https:\/\/www.test4u.eu\/excelpedia\/wp-content\/uploads\/2019\/04\/count.jpg","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/paRnIz-2o","_links":{"self":[{"href":"https:\/\/www.test4u.eu\/excelpedia\/wp-json\/wp\/v2\/posts\/148","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.test4u.eu\/excelpedia\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.test4u.eu\/excelpedia\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.test4u.eu\/excelpedia\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.test4u.eu\/excelpedia\/wp-json\/wp\/v2\/comments?post=148"}],"version-history":[{"count":0,"href":"https:\/\/www.test4u.eu\/excelpedia\/wp-json\/wp\/v2\/posts\/148\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.test4u.eu\/excelpedia\/wp-json\/wp\/v2\/media\/164"}],"wp:attachment":[{"href":"https:\/\/www.test4u.eu\/excelpedia\/wp-json\/wp\/v2\/media?parent=148"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.test4u.eu\/excelpedia\/wp-json\/wp\/v2\/categories?post=148"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.test4u.eu\/excelpedia\/wp-json\/wp\/v2\/tags?post=148"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}