Currently I am using the formula of =SUMPRODUCT(--
LEFT(SUBSTITUTE(B3:B14,"(",""),FIND(" ",B3:B14)-1))

I am using this formula to count various cells in a column such as "4
- 2 Wins" and "10 - Stat Leader" and get the result of 14 without any
of the text that accompanies these two cells, BUT and this is where my
problem comes in...with this formula currently I have to type in 0 -
Empty on all the blank cells because if I have any blank cells the
formula gives me an invalid answer...so i was just curious as to if
there is any way that I can tweak that formula that it would be ok to
have empty cells

thanks in advance