Am currently using this formula but need to add the additional criteria. Any help would be appreciated
=MAX(INDEX(SHEET2!$D$11:$D$1000*(SHEET2!$L$11:$L$1000="147"),0))-MIN(INDEX(SHEET2!$D$11:$D$1000+((SHEET2!$L$11:$L$1000<>"147")*10000),0))+1

The additional criteria to add to the existing "147" criteria is....
SHEET2!$F$11:$F$1000="bank"