Hello forum,
Have this little problem to find out the average speed within a route. In column B is the sequence of the route so sequence no 1 is the first stop etc. After first stop the route begins so I want to find the average speed within the route in other word every sequence 1 has to be out of the calculation. I want the possibility to filter each route to see average speed within the route.
Attached is a test file, I tried using "=SUMPRODUCT(SUBTOTAL(1," but have problems for it to work using function "average"
Thanks
Bookmarks