Related Topics:

Spreadsheet Data Source Functions

Function Wizard Functions

Selecting a Function and Making the Other Required Inputs

FCOUNT

Description: Returns the total number of failures in the specified data source (or the total number of entries in the data sheet that are marked with an F).

Syntax: FCOUNT(Data_Src)

Data_Src is the source data sheet from which the number of failures is taken.

Remarks:

The Data_Src can be one of the following values:

If using a default data source, it must be either 1, 2, 3 or 4, as selected from the Data Source Index drop-down list.
It can take a data sheet name (e.g., "Folio1!Data 1").
It can take a variable name defined in via the Defined Names window (e.g., datasource).

Example:

FCOUNT("Folio1!Data 1") = 305

Note that this value will vary depending on the source data set.

© 1992-2013. ReliaSoft Corporation. ALL RIGHTS RESERVED.