Excel Function

J

Jacob

I know how to use the COUNTIF function to count the numbers in a range greater or lesser than a number such as COUNTIF(A3:A5,">=90"). However, how do i count numbers between a set of numbers such as between 80 and 90?
 
D

David

Jacob

You could use
=COUNT(A3:A5)-COUNTIF(A3:A58,"<=80")-COUNTIF(A3:A58,">=90")

(if you want numbers strictly between 80 and 90)

David

Jacob said:
I know how to use the COUNTIF function to count the numbers in a range
greater or lesser than a number such as COUNTIF(A3:A5,">=90"). However, how
do i count numbers between a set of numbers such as between 80 and 90?
 

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

Top