COUNTIF/SUMPRODUCT(?) to create a matrix from data

Originally Posted by Glenn Kennedy

Check it over. The problem was that I foolishly forgot to extend the raw data raneg BACK one column as well as FORWARD one column. All the NR's are (hopefully) OK now.

Apols. Must be going senile.

Glenn: I was checking through the data for this and there seem to be a few spurious results. For example, we know that only four vehicles were there at 0700 (GO11, SE65, PN15 and KN14). However, on the 'output' tab, the sum of row 6 (the vehicles that arrived at 0700) is 29, implying that there were 29 vehicles that were there at 0700 and departed at various times throughout the day. For example, one vehicle is shown arriving at 0700 and departing at 1100, but that doesn't correspond to any of the departure times of vehicles GO11 (1500), SE65 (0830), PN15 (1230) or KN14 (1200). The arrival and departure times of those four vehicles appear to be showing correctly in the matrix, but there seem to be some additional spurious results too. Any thoughts?

Originally Posted by Sadath31

HI
please see the below formula

HTML Code: 

Thank you Sadath31.