search for the tractor analyse

[Jurgen Smits]

Hello,

I'm stuck with a simple formula for a search of the analyse of a tractor (vehicule) of our company.
I've tried with match, index, offset and combinations, I'm still stuck.

The point is in the yellow cells you can change the start date and the end date of the analyse. The other yellow cell is the list of the vehicules. In the red zone it will only sums of the time between the 2 chosen dates

Thank you very much for helping.

I know it isn't hard but I'm stuck.

Kind regard

Jürgen Smits

 

[Hui]

Please see attached file:


To understand how that works please refer to:
http://chandoo.org/wp/2011/05/26/advanced-sumproduct-queries/

 

[Jurgen Smits]

Thank you very much,

You've show me a new way to explore excel.

Greeting and thanks

Jürgen Smits