How to find the Total Sales column using the IF function without error codes due to the dash in Qty sold column.

\begin{tabular}{|c|c|c|c|c|c|c|c|c|c|c|c|} \hline & A & & B & & C & D & E & F & G & H & I \\ \hline 1 & Game Name & & Unit Cost & & Qty Sold & Location & Total Sales & Genre & Platfori & Publish & \\ \hline 2 & 1/2 Summer + & & & 46 & - & NA Sales & & \multicolumn{2}{|c|}{ Adventur PSP } & \multicolumn{2}{|c|}{ Kaga Crea:e } \\ \hline 3 & 1/2 Summer + & & & 46 & - & EU Sales & & \multicolumn{2}{|c|}{ Adventur PSP } & \multicolumn{2}{|c|}{ Kaga Create } \\ \hline 4 & 1/2 Summer + & & & 46 & 217 & JP Sales & & \multicolumn{2}{|c|}{ Adventur PSP } & \multicolumn{2}{|l|}{ Kaga Create } \\ \hline 5 & 1/2 Summer + & & & 46 & - & Other Sales & & \multicolumn{2}{|c|}{ Adventur PSP } & \multicolumn{2}{|l|}{ Kaga Create } \\ \hline & 12-Sai. Honto no Kimochi & & & 47 & - & NA Sales & & \multicolumn{2}{|c|}{ Adventur 3DS } & Happinet & \\ \hline & 12-Sai. Honto no Kimochi & & & 47 & - & EU Sales & & \multicolumn{2}{|c|}{ Adventur 3DS } & Happinet & \\ \hline 8 & 12-Sai. Honto no Kimochi & & & 47 & 1,489 & JP Sales & & \multicolumn{2}{|c|}{ Adventur 3DS } & Happinet & \\ \hline & 12-Sai. Honto no Kimochi & & & 47 & - & Other Sales & & \multicolumn{2}{|c|}{ Adventur 3DS } & Happinet & \\ \hline & 2 in 1 Combo Pack: Sonic Heroes / Super Monkey Ball Deluxe & & & 50 & 1,800 & NA Sales & & Misc & XB & Sega & \\ \hline & 2 in 1 Combo Pack: Sonic Heroes / Super Monkey Ball Deluxe & & & 50 & 200 & EU Sales & & Misc & XB & Sega & \\ \hline & 2 in 1 Combo Pack: Sonic Heroes / Super Monkey Ball Deluxe & & & 50 & - & JP Sales & & Misc & XB & Sega & \\ \hline & 2 in 1 Combo Pack: Sonic Heroes / Super Monkey Ball Deluxe & & & 50 & 200 & Other Sales & & Misc & XB & Sega & \\ \hline & 2014 FIFA World Cup Brazil & & & 47 & 6,170 & NA Sales & & Sports & PS3 & \multicolumn{2}{|c|}{ Electronic Arts } \\ \hline & 2014 FIFA World Cup Brazil & & & 47 & 14,255 & EU Sales & & Sports & PS3 & \multicolumn{2}{|c|}{ Electronic Arts } \\ \hline & 2014 FIFA World Cup Brazil & & & 47 & 213 & JP Sales & & Sports & PS3 & \multicolumn{2}{|c|}{ Electronic Arts } \\ \hline & 2014 FIFA World Cup Brazil & & & 47 & 4,255 & Other Sales & & Sports & PS3 & \multicolumn{2}{|c|}{ Electronic Arts } \\ \hline & 3rd Super Robot Wars Z Jigoku Hen & & & 46 & - & NA Sales & & \multicolumn{2}{|c|}{ Role-Playi PS3 } & \multicolumn{2}{|c|}{ Namco Bandai Games } \\ \hline & 3rd Super Robot Wars Z Jigoku Hen & & & 46 & - & EU Sales & & \multicolumn{2}{|c|}{ Role-Playi PS3 } & \multicolumn{2}{|c|}{ Namco Bandai Games } \\ \hline 0 & 3rd Super Robot Wars Z Jigoku Hen & & & 46 & 9,130 & JP Sales & & Role-Pla & vi PS3 & Namco Ban & ndai Games \\ \hline \end{tabular}