COUNTAX The COUNTAX function counts nonblank results when evaluating the result of an expression over a table. That is, it works just like the COUNTA function, but is used to iterate through the rows in a table and count rows where the specified expressions results in a non-blank result.
table – The table containing the rows for which the expression will be evaluated.
Expression – The expression to be evaluated for each row of the table.
A whole number.