How can I modify the attached sheet formula so it counts the number of data points for a given wind direction with zero wind and a wave height greater than zero and output in column P rows 5 to 20. See the attached ‘table’ sheet and current formula . Applying a filter to the data table for wind speed of zero I can see that there is 6 inputs which meet the criteria 1x NE and 4 x WSW. The wave table has been modified to show how looking for outputs to be presented in RED for illustration.
As an add on what formula would allow me to count occurences for ALL directions with wave height greater than zero so output is a single sum of 6 as in this scenario.?