|
03-30-2019, 08:44 AM
|
|
Novice
|
|
Join Date: Feb 2019
Location: Singapore
Posts: 7
|
|
Quote:
Originally Posted by Greggey1
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.
|
Then, the formula changed to
=SUMPRODUCT(ISNUMBER(1/(0+LEFT(B5:B14)=9))*(LEN(B5:B14)-LEN(SUBSTITUTE(B5:B14,"/",""))+1))
Regards
Bosco
|