Quote:
Originally Posted by bosco_yip
Or…....................
=SUMPRODUCT(0+(LEN(B5:B14)>0)*(LEN(B5:B14)-LEN(SUBSTITUTE(B5:B14,"/",""))+1))
Regards
Bosco
|
That's very close. The only thing is if someone who enters a number not beginning with 9 I don't want it to count. Thanks for the help.