Leading the way in Microsoft Office Development

COUNT

 -

Returns the number of numeric values in a list or array of numbers.

COUNTA

 -

Returns the number of non blank cells in a list or cell range.

COUNTBLANK

 -

Returns the number of cells which are blank in a list of cell range.

COUNTIF

 -

Returns the number of cells with a value that satisfies a condition.

This function is useful when you have a single counting criteria. For more complex criteria you can use DCOUNT.

DCOUNT

 -

Returns the total number of values in a database column satisfying a condition.

SUBTOTAL

 -

Returns the subtotal of values in a list or database columns.

This function is useful when you need to get the count of rows that have been filtered using the AutoFilter.

COUNTFORMAT

This is a user-defined function.