ADD NUMBERS HAVING TEXT WITH IT

3 Formulas to do this

Formula1 in B2:  =SUMPRODUCT(--SUBSTITUTE(UPPER(G33:G37),"K",""))
Formula2 in B3:  =SUM(--LEFT(G33:G37,LEN(G33:G37)-1))        Press Ctrl+Shft+Enter
Formula3 in B4:  =SUMPRODUCT(--(LEFT(G33:G37,LEN(G33:G37)-1)))    Press Ctrl+Shft+Enter