Count table columns

Generic formula
COLUMNS(table)
Summary
To count columns in an Excel table, you can use the COLUMNS function. In the example shown, the formula in I4 is:
=COLUMNS(Table1)
Explanation
This formula uses structured referencing, a syntax that allows table parts to be referred to by name. When a table is referred to by the name only, Excel returns a reference to the data region of the table only. In this case, the entire table range is B4:F104 so Table1 returns the range B5:F105 to the COLUMNS function.
COLUMNS then returns a final result of 5, since there are 5 columns in the table.
See also
Download 200+ Excel Shortcuts
Get over 200 Excel shortcuts for Windows and Mac in one handy PDF.