Forum Discussion
Countif when the criteria is a certain number in a row
I am looking for a count function that counts the number of occurrences happens but must meet a 3 in a row criteria. Example: For column BG count only if a value > 12 occurs 3 or more times in...
=IF(BG3755>12,BH3754+1,0)I'd apply this helper formula in cell BH3755 and fill down as required.
=COUNTIF(BH3755:BH3768,3)COUNTIF returns the intended result.