Try posting a small subset of your data, and what you want to see.

It sounds like using a SUMIF and COUNTIF function could work. You would need to sum the distance column where the speed equals a certain value, and count the number of occurances?