Announcement

Collapse
No announcement yet.

COUNTIF Between Two Numbers

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • COUNTIF Between Two Numbers



    I was recently asked how to use the COUNTIF function to count the number of values in an array that are between two numbers, such as num1 < x <= num2. It can be pretty simple if you use two COUNTIF functions and subtract the results. Examples can be found on the following page, along with a demo spreadsheet.

    Excel COUNTIF Function for Two Conditions

    Enjoy,
    Jon
    The Excel Nexus :: Excel Templates
Working...
X