Please enable JavaScript to view the comments powered by Disqus.


COUNTIF(...B4:B13,(..."<>"&"A"))

Using countif to count other then a given criteria in Excel

The COUNTIF() function when is coupled with "other then" logical operator can be used to count all other thing except the given criteria. We use "<>" to represent "other then" criteria. 


Used Functions

Category: Statistical

Counts the number of cells within a range that meet the given criteria

Syntax

COUNTIF(range, criteria)

Lets chat on this