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
Financial Ratios Accounting Cycle Accounting Principles Financial Accounting Basics Financial Statements Reporting Bad Debts Current Assets Long-term Assets Voucher System Partnership Depreciation Work Sheet - 10 Column Work Sheet Difference Between Reserve and Fund Accounting for Leases Capital reduction and reconstruction Absorption of Company Amalgamation Accounting for Installment Sales Basis of Recording Profit and Loss Branch Accounting Construction Contracts Revenue Recognition Accounting for Groups Financial Analysis Events After the Balance Sheet Date Deferred Tax Cost Accounting Activity Based Costing (ABC) Throughput Accounting Relevant Cost Break Even Analysis Standard Costing Inventory Management Payroll Accounting Royalty Accounting Statistics Master Budget Salary Income Microsoft Excel Tutorial How to Count Number of Records between Two Dates How to sum values in excel based on a criteria Finding the first login and last logout time of employees How to Print Salary Slips Using VLookup Formula in Excel How to Calculate Net Present Value (NPV) in Excel Income tax calculation excel sheet for salaried individuals How to Calculate Pay Back Period in Excel How to Calculate Declining Balance in Excel Using Formula How to Calculate Double Declining Balance in Excel How to Calculate Number of Payments on A Loan In Excel Using NPER Count the Number of Excel Records That Fall Between Two Dates How to Count Cells between Two Numbers in Excel How to Prepare Exam Result in Excel 3D Sum Multiple Worksheets How to Count Specific Text in Excel Other Topics Share or Stock Valuation Model Financial Management Topics Kinds of Endorsement Letter of Credit, Kinds and Its Advantages/ Utilities Modern Functions of a Commercial Banks Difference Between Secured And Unsecured Loan Excel conditional formatting red if negative green if positive How to Remove Extra Spaces in Excel Result Card or Result Sheet Creation Using Excel Basic Accounting MCQS Multiple Choice Questions