Trying to Find Average of Values Based on Lookup Range

Hello,
I am trying to simplify data log dumps that I get that could be up to 1000 rows long. Column A is % Utilization and ranges from 0.00 - 100.00. I want to be able to get the average of the values of column B that fall between each whole % range (ex. 24.00 - 24.99) and return that average to Column D (column C is whole % numbers between 1 - 100). There is no set Range between the % values, it could be 4 rows, it could be 40 rows. I have attached a demo sheet that gives an idea as to what I have and how I would like to see the data. Any help would be greatly appreciated!

Thanks,
Bryce

Try

=AVERAGEIFS($B$3:$B$33,$A$3:$A$33,">="&C11,$A$3:$A$33,"<"&C11+1)

Thank you for your reply. The biggest problem i have is that in your solution I would have to manually select my ranges. I would like it to be able to find the range (>=0.00 and <=0.99, >=1.00 and <=1.99, etc). The logs I'm dealing with have thousands of lines of data, so being able to automatically find the ranges is key.

Thanks,
Bryce

Hey Jonmo,
Thank you for pointing out the rounding! Your formula works great! You guys here always amaze me on your Excel foo!!! One other quick cosmetic question... for ranges that "aren't" represented in the log data I get a "#DIV/0!" code which I know is normal. Is there a way to have it display as 0 rather than the error code?

Thanks again!
Bryce

You're welcome.

You can use IFERROR

=IFERROR(AVERAGEIFS($B$3:$B$33,$A$3:$A$33,">="&C11,$A$3:$A$33,"<"&C11+1),0)

Well that did it! Thank you very much for all of your help Jonmo! I love this place!

Thanks!!!

Bryce

You're welcome.