This is fine.

Don't want
No
Slow

Thanks again.

"Gary''s Student" wrote:

You are welcome! You can use an array formula instead of the helper column,
but it might get really slow.
--
Gary''s Student - gsnu201001


"Steve" wrote:

Perfect.

I thought it'd be simple, but actually simplier than I thought.

Thanks again,

Steve

"Gary''s Student" wrote:

In H1 enter1
In H2 enter:
=IF(G2="",H1+1,0) and copy down

In another cell the answer is:
=MAX(H:H)
--
Gary''s Student - gsnu201001


"Steve" wrote:

I have this formula in column G
=IF(SUMIF(Montana!$A$3:$A$700,C3,Montana!$N$3:$N$7 00)0,SUMIF(Montana!$A$3:$A$700,C3,Montana!$N$3:$N $700),"")

In Column H, I like to count the maximum number of consecutive blanks in
that entire range.
Meaning, there may 5 consective blanks, then 3, then 18, then 7. I'd like 18
to be returned.

Thanks,

Steve