This should do it for you, at least it works with your test cases.
Enter the formula out in column E, then extend the formula down the sheet
this assumes your first row is at 2
=IF(A2B2,1,0)+IF(C2<B2,IF(A2B2,1,0),0)+IF(B2C2, IF(A2B2,1,0),0)+IF(C2D2,IF(B2C2,IF(A2B2,1,0),0 ),0)

JLatham

"SteveC" wrote:

Col A through D contain the data. Col E contains the formula I'm asking
about:
Col A Col B Col C Col D Col E
7 6 7 2 1
4 3 2 1 4
8 10 9 8 -
5 3 2 10 3

I'd like to Col E to count consecutive improvements for each row of data
starting in Col A relative to Col B, then Col B relative to Col C.

Is there a way to do this?

Thanks a lot!