COUNTNEG function

Description

Count negative numbers function. COUNTNEG(range) counts the number of negative values (< 0) in range.

Example

COUNTNEG(A1:A5) returns 3 if the contents of 3 cells in the range A1:A5 are negative values.

Calculator

COUNTNEG(,,,)

Related functions

This site uses cookies to store information on your computer. More info...