# How to Count Cells between Two Numbers in Excel

There are circumstances under which you have to represent data in range form. In this case, you can take support from COUNTIFS formula to represent any set of data in a range format. Most of the common situation of this arises when for example, Excel sheet contains marks obtained by students in the exam.

Formula

=COUNTIFS(\$C\$6:\$C\$13,">=80",\$C\$6:\$C\$13,"<=100")

Following is the data of students who appeared in the examination of a school situated in south east London.

 S. NO STUDENT MARKS OBTAINED 1 John 67 2 Cena 77 3 Michael 78 4 Andy 89 5 Beevan 90 6 Shaun 51 7 Marie 50 8 Juliet 92

The management of the school has requested you to prepare a report which classify student according to the class ranges such as total number of students who obtained marks:

• Equal or greater than 80 but less than or equal to 100,
• Equal or greater than 70 but less than or equal to 79,
• Equal or greater than 60 but less than or equal to 69,
• Equal or greater than 50 but less than or equal to 59.

In order to solve this problem of how to count cells between two numbers in Excel, we have taken the support of COUNTIFS formula. The data in Excel sheet has been arranged in such a manner that student name are in cell B6 to B13 while marks obtained are in C6 to C13.  Now you have seen how easily we done this task in Excel using COUNTIFS function.

Contents