• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 388
  • Last Modified:

Count If value falls with in a range


I'm trying to count, in a range of cells (A1 : A2500), how many fall between certain values, such as between 0 and 1000; 1001 & 5000; 5001 & 6000.

  • 2
2 Solutions

Open in new window

First one counts 0 - 1000, second one 1001-5000, etc
LadkissonAuthor Commented:
I think I came up with the same solution:):)


my next question is how do I sum up values based on this split? So I need to know a total for  values that fall under each category
barry houdiniCommented:
If you are using Excel 2007 or later then COUNTIFS is usually faster, e.g.


and then to sum those you can use SUMIFS


regards, barry
For that, you need to define the bands

Say 0 - 1000 is called "1"
next bracket is called "2"
Next is called "3"

Now on B1, enter this


Drag it down. Then you can do pivot table or do sumif.


would sum all the 1st band/bracket


would sum all the 2nd band/bracket
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now