Taking out Emptys
 

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

Taking out Emptys
 

With respect, it should be clear to you by now that the way you have set up
your data is causing you great trouble.

You really should have the data in columns not combining three bits of data
(2 - 4 Win) in a single column. Use Data | Text-to-Columns to do this.
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

wrote in message
ups.com...
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