Count (with a condition)

Last updated 9 November 2026

Function reference › Other Functions

1 GIAnalyzer function for Excel. Optional arguments are shown in [brackets].

GIA_Other_Count

Return the number of values in the range of cells, meeting a chosen criteria (zero/negative/positive).

GIA_Other_Count(Range, Condition)
ArgumentUseDescription
RangeRequiredThe range of cells.
ConditionRequiredThe criteria that defines which values will be chosen (zero/negative/positive).