filtering numbers?

Or a slight change - sum all values in B79 to B114 where those values are less than the rounded result in C5. Then add the number of values in B79 to B114 where they are equal or greater than the rounded result in C5. This may not inprove but what do you think? Your logic sounds correct but I'm still geting a wrong result when compared with a calculator.
I've attached another example showing each calculation done with a calculator. This time with the correct result of 18.7 not 16.6 as previously shown - apologies.