Sum row of text with assigned values to numeric cells

[Tsclute]

Since I do not know what I am doing I am unable to find a previous thread that applies.

I create crochet patterns and am using Excel for help.

I have 2 "words" with assigned values. Either word can appear in any column.

Data info:
Inc = 2, dec = 1

Rows Col2 Col3 Col4 Total Stitches
Row1 inc 4sc inc (8)
Row2 dec 6sc (7)
Row3 6sc inc (8)

Please let me know if you know additional info.

 

[DanteAmor]

Glad we could help & thanks for the feedback

 

[Rick Rothstein]

I have the advantage of being able to edit the OP & see the correct layout

Which can also be seen by clicking the Reply hyperlink on the OP's first message.

 

[CA_Punit]

If there are other Text with Numbers you can also use : With Ctrl+Shift+Enter

Book1
	K	L	M	N	O
19
20				Total
21	inc	4punit	inc	8
22
23
24
Sheet1

Cell Formulas
Range	Formula
N21	N21	=SUM(IFERROR(MID(SUBSTITUTE(SUBSTITUTE(K21:M21,"inc",2),"dec",1),ROW(A1:A25),1)+0,0))

Named Ranges
Name	Refers To	Cells
_FilterDatabase	=Sheet1!$A$3:$A$9	N21