{"id":2324,"date":"2015-03-31T11:19:29","date_gmt":"2015-03-31T11:19:29","guid":{"rendered":"http:\/\/www.microsofttraining.net\/b\/?p=2324"},"modified":"2023-12-31T00:05:47","modified_gmt":"2023-12-31T00:05:47","slug":"count-and-counta-in-excel","status":"publish","type":"post","link":"https:\/\/www.stl-training.co.uk\/b\/count-and-counta-in-excel\/","title":{"rendered":"Count and CountA in Excel"},"content":{"rendered":"

What’s the difference between Count and\u00a0CountA in Excel?<\/strong><\/h2>\n

The\u00a0Count\u00a0<\/strong>function is one of the 400 functions in Excel. Count<\/strong> as the name suggests, counts the number of cells selected that contain numbers. You can use\u00a0the\u00a0Count\u00a0<\/span>function to obtain\u00a0the number of values within a range, rather than the total of those values.<\/p>\n

If we wanted to count the number of values between A1 and A7 we could use the formula<\/p>\n

=COUNT(A1:A7)<\/strong><\/p>\n

\"Countfx\"<\/a><\/p>\n

\"Countresult\"<\/a><\/p>\n

This has counted the number of values in the list.<\/p>\n

If you have text in that range, Count<\/strong> behaves differently.<\/p>\n

\"Countntwrk\"<\/a><\/p>\n

The result is 6, because Count\u00a0<\/strong>has a limitation.\u00a0Count<\/strong> only returns the number of values present, it doesn’t include text.<\/p>\n

To overcome this, we can use another, similar function,\u00a0CountA<\/strong>.<\/p>\n

So the difference between Count and CountA in Excel is that CountA\u00a0<\/strong>will return the number of values and text in a list.<\/p>\n

\"Counta\"<\/a><\/p>\n

\"Countaresult\"<\/a>
using count and counta in Excel will produce different results<\/figcaption><\/figure>\n

If you need to find out have many numbers you have, use Count.<\/strong><\/p>\n

If you have text, or a mixture of text and values, use\u00a0CountA.<\/strong><\/p>\n

An example of CountA\u00a0<\/strong>could be when you require the total number of Staff in a list. You can see this in the practice example below.<\/p>\n

\"Countareal\"<\/a><\/p>\n

Additional resources<\/h2>\n

What is the difference between Count and CountA?<\/a><\/p>\n

CountA function<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

What’s the difference between Count and\u00a0CountA in Excel? The\u00a0Count\u00a0function is one of the 400 functions in Excel. Count as the name suggests, counts the number of cells selected that contain numbers. You can use\u00a0the\u00a0Count\u00a0function to obtain\u00a0the number of values within a range, rather than the total of those values. If we wanted to count the […]<\/p>\n","protected":false},"author":5,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[4,6],"tags":[116,117,120,190],"class_list":["post-2324","post","type-post","status-publish","format-standard","hentry","category-excel-training","category-hints-tips","tag-count-and-counta","tag-count-only-values","tag-counting-text-and-numbers","tag-excel-count-counta"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/posts\/2324","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/comments?post=2324"}],"version-history":[{"count":1,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/posts\/2324\/revisions"}],"predecessor-version":[{"id":6891,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/posts\/2324\/revisions\/6891"}],"wp:attachment":[{"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/media?parent=2324"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/categories?post=2324"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/tags?post=2324"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}