COLUMNS then returns a final result of 5, since there are 5 columns in the table.
Count table columns
To count columns in an Excel table, you can use the COLUMNS function. In the example shown, the formula in I4 is: =COLUMNS(Table1) The result is 5, the number of columns in Table1 as shown.
