SUM fuction to ignore text .

[XeenGR]

Hello everyone , i'm new to the forum and i hope you could me some advice . Also i like to mention that i'm new also to the excel .
I try to make a worksheet that counts some cells with different values . But i need sometimes to add text on the master cell but with the sum function ill get a Value error.. till now i couldn't find a way around . Would nice if some of you could help me out of this situation . The formula is =SUM(K148*5)+(L148*5)+((M148*5)*1.2)+((N148*5)). The only cell that may have not a number but a text in this example is the K148. I hope you understand my problem and i'm sorry about my english since its not my native language .

 

[Peter_SSs]

@XeenGR
Just wondering - did the formula in post #3 still give you a #VALUE error if you had text in K148?
For me, it gives the same value as the much more complicated formula from post #2.

Example:

20 11 22.xlsm
	K	L	M	N	O	P	Q
147						Post #2	Post #3
148	10x	2	5	3		55	55
SUM Ignore Text

Cell Formulas
Range	Formula
P148	P148	=SUM(IFERROR(K148*5,0)+(IFERROR(L148*5,0)+((IFERROR(M148*5,0)*1.2)+((IFERROR(N148*5,0))))))
Q148	Q148	=SUM(K148:N148)*5+M148