Excel Help (CountIF)

Associate
Joined
27 Jul 2009
Posts
590
Location
UK
COUNT counts all numeric values.

You need to use a combination of it and COUNTIF, something like the below should do it.

Count all numeric values - those greater than 10 - those less than or equal to 1.

Code:
=SUM(COUNT(A1:A7) -COUNTIF(A1:A7,">10") -COUNTIF(A1:A7, "<=0"))
 
Back
Top Bottom