Skip to main content
MedCalc
Mail a PDF copy of this page to:
(Your email address will not be added to a mailing list)
working
Show menu

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