Share via

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

SpiderM33 20 Reputation points
2026-05-23T13:56:53.1266667+00:00

how do i get excel to do an average 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

1 answer

Sort by: Most helpful
Most helpful Newest Oldest

  1. AI answer

    2026-05-23T13:57:07.8166667+00:00

    Use conditional averages with AVERAGEIF (one condition) or AVERAGEIFS (multiple conditions). Assuming the percentages are in cells A2:A9:

    1. Average of values from 0% to 24.99% 
         =AVERAGEIFS(A2:A9, A2:A9, ">=0%", A2:A9, "<25%")
    2. Average of values from 25% to 49.99% 
         =AVERAGEIFS(A2:A9, A2:A9, ">=25%", A2:A9, "<50%")
    3. Average of values from 50% to 74.99% 
         =AVERAGEIFS(A2:A9, A2:A9, ">=50%", A2:A9, "<75%")
    4. Average of values from 75% to 100% 
         =AVERAGEIFS(A2:A9, A2:A9, ">=75%", A2:A9, "<=100%")

    Each formula returns the average of the percentages that fall within the specified range.

    If only a single condition is needed (for example, “greater than 50%”), AVERAGEIF can be used as shown in the context:

    =AVERAGEIF(A2:A9, ">50%")

    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.