Account for cert count when end market isn't populated.

[mikelietz]

18Chesa and 1889 tried to track yellow zoned certs based on (end) market price.

But until end market price is set, they didn't count. Updated version for 1889 for reference.

=SUM( IF(AND(F$14<55,F$14>0),0,(G3+IF(ISBLANK(F3),0,-1))), IF(AND(H$14<55,H$14>0),0,(I3+IF(ISBLANK(H3),0,-1))), IF(AND(J$14<55,J$14>0),0,(K3+IF(ISBLANK(J3),0,-1))), IF(AND(L$14<55,L$14>0),0,(M3+IF(ISBLANK(L3),0,-1))), IF(AND(N$14<55,N$14>0),0,(O3+IF(ISBLANK(N3),0,-1))), IF(AND(P$14<55,P$14>0),0,(Q3+IF(ISBLANK(P3),0,-1))), IF(AND(R$14<55,R$14>0),0,(S3+IF(ISBLANK(R3),0,-1))), IF(ISERR((FIND("1",T3,(0+1))-1)),0,1), IF(ISERR((FIND("2",T3,(0+1))-1)),0,1), IF(ISERR((FIND("3",T3,(0+1))-1)),0,1), IF(ISERR((FIND("4",T3,(0+1))-1)),0,1), IF(ISERR((FIND("5",T3,(0+1))-1)),0,1), IF(ISERR((FIND("6",T3,(0+1))-1)),0,1), IF(ISERR((FIND("7",T3,(0+1))-1)),0,1))

[mikelietz]

1830 will need this fixed.