Continuous Value Count Question

[macb333]

I need to count the number of continuous values within a range. For example, suppose I had a year of temp data (365 values) how would I count the number of continuous days with temps between 70 and 75. if given:
A B
72 68
75 70
73 72
71 71
69 68
70 67
68 71
72 75
69 76

A: I would like the formula to return "4" , i only want to count the value if the previous value is also within the range.
b: I would like the formula to return "5" , and I would like a max continuous formula/value of "3"

I am familiar with the count,countif,countifs commands. I have tried the frequency command, but am unsure of how to arrange the syntax, any help is greatly appreciated.

 

[T. Valko]

How can I modify/adjust the formula to get the longest streak of consecutive days -- it currently counts all consecutive values and sums them. e.g. I get "75"(as sum of all consecutive days) instead of "20" (longest consecutive period). I may be asking too much, but I need to be able to perform both calculations.

What formula are you using?

I don't see any formulas in this thread that will do a sum.