Syntax<\/h3>\n
COLUMNS(range)<\/strong><\/p>\n As such, the syntax of the formula is pretty straightforward. But going through a few practical examples reinforces our understanding. So, without further ado, let us dive right in. Please have a look at the snapshot below.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2018\/07\/COLUMNS-formula-Illustration-Frame-1.png” alt=”COLUMNS Formula in Google Sheets” title_text=”columns-formula-usage” _builder_version=”3.25.2″][\/et_pb_image][et_pb_text _builder_version=”3.27.4″]<\/p>\n In order for us to input values directly as a range, we need to use a pair of curly brackets. We illustrated this in the first example. How do we specify the columns and rows in such a range? It is simple, really. While we separate the values into columns using a comma, we use a semi-colon to separate the values into rows. And if we observe closely, the range\u00a0<\/span>{62,72,52;81,87,73}<\/strong>\u00a0<\/span>consists of two rows and three columns. Therefore the formula returned the output as 3.<\/p>\n In the second example, we used the reference to the range of cells instead of inputting the values directly. The range\u00a0<\/span>B2:D3<\/strong>\u00a0also spans across two rows and three columns. Hence it evaluates the output to 3, just like the formula in the\u00a0first example did.<\/p>\n Regardless of the number of rows within the range, the COLUMNS formula returns only the number of columns within that range. The range\u00a0<\/span>B2:D2<\/strong>\u00a0<\/span>used in the third example has just one row, but that doesn\u2019t impact the output. That is because there are three columns from B through D.<\/p>\n The fourth example shows just another range, that consists of four columns. Hence the formula returns 4 as output.<\/p>\n [\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>\n","protected":false},"excerpt":{"rendered":" Let us say we have a range of cells in a spreadsheet, and we want to know how many columns it has spread across. If there are only a few of them, we could probably do a quick observation and manually count the number. But there can be instances where columns in a range are […]<\/p>\n","protected":false},"author":40,"featured_media":8974,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_et_pb_use_builder":"on","_et_pb_old_content":"Let us say we have a range of cells in a spreadsheet, and we want to know how many columns it has spread across. If there are only a few of them, we could probably do a quick observation and manually count the number. But there can be instances where columns in a range are more than just a few. Or we may need to generate the output dynamically, rather than relying upon manual observation. In such scenarios, the appropriately named COLUMNS<\/a> formula in Google Sheets can help us.\n\n
Usage: COLUMNS formula in Google Sheets<\/h3>\n
Syntax<\/h3>\nCOLUMNS(range)<\/strong>\n
\n \t
Usage: COLUMNS formula in Google Sheets<\/h3>\nAs such, the syntax of the formula is pretty straightforward. But going through a few practical examples reinforces our understanding. So, without further ado, let us dive right in. Please have a look at the snapshot below.\n\n
![\"COLUMNS](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2018\/07\/COLUMNS-formula-Illustration-Frame-1.png\")
\n\nIn order for us to input values directly as a range, we need to use a pair of curly brackets. We illustrated this in the first example. How do we specify the columns and rows in such a range? It is simple, really. While we separate the values into columns using a comma, we use a semi-colon to separate the values into rows. And if we observe closely, the range {62,72,52;81,87,73}<\/strong> consists of two rows and three columns. Therefore the formula returned the output as 3.\n\nIn the second example, we used the reference to the range of cells instead of inputting the values directly. The range B2:D3<\/strong>\u00a0also spans across two rows and three columns. Hence it evaluates the output to 3, just like the formula in the\u00a0first example did.\n\nRegardless of the number of rows within the range, the COLUMNS formula returns only the number of columns within that range. The range B2:D2<\/strong> used in the third example has just one row, but that doesn't impact the output. That is because there are three columns from B through D.\n\nThe fourth example shows just another range, that consists of four columns. Hence the formula returns 4 as output.","_et_gb_content_width":"","footnotes":""},"categories":[54],"tags":[39,28],"class_list":["post-8973","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-google-sheets-formulas","tag-connections-t","tag-spreadsheets"],"acf":[],"_links":{"self":[{"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/posts\/8973","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/users\/40"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/comments?post=8973"}],"version-history":[{"count":0,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/posts\/8973\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/media\/8974"}],"wp:attachment":[{"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/media?parent=8973"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/categories?post=8973"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/tags?post=8973"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}