CountIf and AND

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
 
D

Dave R.

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Count Number of Unique Cells That Don't Have Certain Characters 0
Using <= in countifs statement 1
countifs Function not giving desired result with date criteria 2
Excel Countif Function - Calculating Between Two Sets of Values 3
Finding the weighted average of text that have been given values 1
COUNTIFS (the numbers in a column, when subtracted meet a certain criteria) 1
Countif formula perhaps 8
Need countifs forumla to analize in a time range 2

Top