I have a spreadsheet showing:

Vehicle arrival times - 07:05. 09:01, 10:00 etc
Vehicle departure times = 08:06, 18:32 etc
Type of vehicle - 7.5t, 17t. 40t etc

I want to create a sum which calculates how many arrivals and
departures there are in a given time period according to vehicle type

e.g.

Between 07:00 - 07:59: 6, 7.5t lorries arrive and 12, 17t lorries
arrive
Between 08:00 - 08:59: 2, 7.5t lorries arrive and 2, 17t lorries
arrive

I've tried a sumproduct function but can't seem to get it quite right.
Is this the correct function to use or is there some other way?


--
lmeg
------------------------------------------------------------------------
lmeg's Profile: http://www.excelforum.com/member.php...o&userid=35857
View this thread: http://www.excelforum.com/showthread...hreadid=556487