Share via

How do i get excel to do an count based on the ranges of numbers in a column?

SpiderM33 20 Reputation points
2026-05-23T14:21:19.7333333+00:00

how do i get excel to do an count based on the ranges of numbers in a column?

Lets say I have a column of #'s I have 50%, 50%, 33%, 25%, 15% 75%, 100% and 68%.

What I want to figure out how to do is have a formula that will count ranges between 0% and 24.99%, 25% and 49.99%, 50% and 74.99% and 75% to 100% and give me the average of people that I have within that range.

Microsoft 365 and Office | Excel | Other | Windows
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest

  1. AI answer

    2026-05-23T14:21:32.6666667+00:00

    Assume the percentages are real numbers in A2:A9 (0.5 for 50%, 0.33 for 33%, etc.). Use COUNTIFS to count how many fall in each range, then divide by the total count to get the average (proportion) in that range.

    Example formulas:

    Total count (people):

    =COUNT(A2:A9)

    0%–24.99%:

    =COUNTIFS(A2:A9,">=0",A2:A9,"<0.25")/COUNT(A2:A9)

    25%–49.99%:

    =COUNTIFS(A2:A9,">=0.25",A2:A9,"<0.5")/COUNT(A2:A9)

    50%–74.99%:

    =COUNTIFS(A2:A9,">=0.5",A2:A9,"<0.75")/COUNT(A2:A9)

    75%–100%:

    =COUNTIFS(A2:A9,">=0.75",A2:A9,"<=1")/COUNT(A2:A9)

    Format the result cells as Percentage to see the average share of people in each range.

    If the values are stored as whole-number percentages (50, 33, 25, …), adjust the thresholds accordingly (0 to 24.99, 25 to 49.99, etc.).

    References:

    AI-generated content may be incorrect. Read our transparency notes for more information.

    Was this answer helpful?

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.