COUNT3D

Counts the number of numeric entries in a range of cells in the whole workbook.

COUNT3D is very similar to the COUNT function of Microsoft Excel. The main difference is that COUNT3D considers all worksheets, while the original COUNT function doesn't.

Syntax

COUNT3D(range_input, include_current)

range_input - is the range from which you want to count the numeric entries.
include_current - Optional. Boolean argument , either TRUE or FALSE. Decides whether the current worksheet is included in the function's consideration. TRUE means the current worksheet will be considered, and vice versa.

Remarks