• ABS Function
• AVERAGE Function
• CGROUP Function
• CGROUPT Function
• COLCOUNT Function
• COUNTIF function
• EXP Function
• FV Function
• LOG Function
• Mathematical and Financial Functions
• MAX Function
• MEDIAN Function
• MIN Function
• MKDEC Function
• MKINT Function
• MOD Function
• POS Function
• PV Function
• R Function
• RATIO Function
• RC Function
• RCNV Function
• RCR Function
• RCTOTAL Function
• ROUND Function
• ROWCOUNT Function
• RR Function
• RRTOTAL Function
• STDDEV Function
• SUM Function
• TOTAL Function

COLCOUNT Function

The COLCOUNT function returns the number of columns in the first found instance of the specified table.

Syntax

COLCOUNT(tablename)

The COLCOUNT function searches text areas of the document in the following order, Main Document, Headers, Footers, Carry Forward, Auto Copy, returning the number of columns for the first table encountered that matches the specified table name.

Example 1

Entering COLCOUNT(ABC) in a cell returns the number of columns in table ABC.

Related Topics

• Mathematical and Financial Functions