Taking out Emptys

  • Thread starter Thread starter derr04
  • Start date Start date
D

derr04

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
 
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
 
Back
Top