Try...

M3, copied down:

=IF(L3<"",COUNTBLANK(INDEX($L$2:L2,MATCH(9.999999 99999999E+307,$L$2:L2))
:L3),"")

Hope this helps!

In article ,
"Luke" wrote:

I need formula in column M to count number of blank cells in column L since
the last entry
Sheet looks like this:
L2 1 M2
L3 M3
L4 M4
L5 M5
L6 1 M6 3
L7 1 M7 0
L8 M8
L9 1 M9 1

Thank you
Luke