count if

One way ...

=sumproduct((A1:A100>=0.5)*(A1:A100<=1.0)*(B1:B100>=3)*(B1:B100<=4))


Regards.

Originally Posted by alexsmalley

I have a time series of wave data comprising wave height, period, direction etc. I need to count the occurences of waves of a certain height and period.

For example I would like to count the occurence of waves with a height of 0.5-1.0m and a period of 3-4 secs. I have tried using the countif function and the count function with a nested if function but with no luck.

Here is an example of the series of data I have

height period
(m) (s)
0.3 5.4
0.4 5.6
0.4 6
0.3 -
0.3 4.4
0.3 4
0.3 4
0.3 4.1
0.3 3.7
0.3 4.1
0.3 3.5
0.3 3.6
0.3 3.6
0.3 4.2
0.3 4.1
0.3 3.8
0.3 3.8
0.3 3.5
0.3 3.7
0.3 4
0.3 3.8
0.3 4
0.3 3.6
0.3 4.2
0.3 4.2
0.3 3.7
0.3 4
0.3 4.3
0.3 4.5
0.3 4.5
0.3 4.2


Any ideas would be greatly appreciated

Thanks

Alex