Count first instance in series above a condition

Hi all,

I have a series of acceleration data that is sampled at 0.1s from which I am trying to count efforts above a threshold of 2.5m/s/s

Currently, if I do a normal count using a condition, I am getting a count of all occurrences in a series that are above 2.5 where I only want to count the first occurrence as they are all in the same effort. For the below example =countif(array,>=2.5) would result in a count of 5. I want it to be 1 as they are the same effort. The data set is large and many of these efforts occur.

0.831396818
1.749603987
2.432745457
2.874011517
3.082041025
3.082629681
2.915354013
2.620022297
2.236617327
1.8116467


Thanks in advance

please use the attached file of MarvinP GURU (Say TQ)

Cell E3 formula

Formula:

Please Login or Register  to view this content.

Perfect MarvinP thank you so much!