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