CountIf and AND

  • Thread starter Thread starter Anita
  • Start date Start date
A

Anita

I want to count the number of entries in a list that are
between 2 specific numbers. I have been trying to use a
combination of Countif and And, but can't get them to
work. Suggestions?

Thx.
Anita
 
You can use 2 countifs for that; like

=COUNTIF(A1:A10,">10")-COUNTIF(A1:A10,">15")

that counts the number in the range greater than 10, then subtracts any
greater than 15.
 
Back
Top