I am looking to generate a table (see ‘table’ sheet) which will lookup a wind direction (eg N, NE, WSW etc) together with a wind speed range (eg between 0 – 5 knts) on a separate sheet of data and count the number of times these paramters are met. In other words on ‘Table’ sheet cell C5 formula to lookup the specified wind direction (N) in the table row(s) and the specified table column wind speed(s) (0 – 5, 5-10 etc) knots and return the number of occurrences for the given direction and speed ranges. attempts at using vlookup have failed.
In cell L5 on the same ‘Table’ sheet I am also looking to calculate the average speed for the various specified wind direction and combined speed ranges.
How might it be possible to dynamically change this table by selecting a specific time period such as year or month(s)?? to alter the various occurence values ?