CountIF

[Arthur]

I have a column of numbers. I want to count the occurences
within different ranges of numbers (like between 40 and
50).

I've tried the formulas below but they produce errors:

CountIf(Range,(>="40",<="50"))
CountIf(Range,and(>="40",<="50"))

Is there a way to do this?

Art

 

[Peo Sjoblom]

=COUNTIF(Range,">=40")-COUNTIF(Range,">50")

change ">50" to ">=50" if you don't want to include 50

 

[Don Guillett]

try
=sumproduct((rngA>=40)*(rngA<50))