Do you know how to use the COLUMNS function in Excel? This little-known function can be incredibly useful for businesses and individuals alike. COLUMNS returns the count of columns in a given reference as a number. In other words, COLUMNS tells you how many columns are in a given range or array. The COLUMNS function is versatile and easy to use, so let's take a closer look at how it works!