Excel formula needed for......

Last Edited By Krjb Donovan
Last Updated: Mar 05, 2014 09:31 PM GMT


Hi- I am usingspreadsheet put together a times trial for cars. I need to find the speed by dividing distance traveled by time. How do I put this into a formula for multiple cars with different times? Thank you for your help.



assume you have you headers in row 1 of the cells specified below

A1: Car ID B1: time C1: Distance D1: Speed

so in D2 you would put


then select d2 and copy the cells.

Select d3 and all the cells below D3 that need the formula and then paste. that should fill column D with the speeds for each car listed. If that isn't what you want, post back with a specific example including where the information is located.

if you wanted the average speed for multiple cars in this situation, you would go to the next blank cell in column B and do (assume that is in Row 20

B20: =sum(B2:B19) C20: =sum(C2:C19) D20 =C20/B20

so you can just add up the total distances and the total times and do the division with the sums to get speed.


©2017 eLuminary LLC. All rights reserved.