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]

Hi and welcome to MrExcel

Try this array formula:

varios 08jun2020.xlsm
	A	B	C	D	E
1					Total
2		Inc	4	Inc	8
3		dec	6	sc	7
4		6	sc	Inc	8
Hoja1

Cell Formulas
Range	Formula
E2:E4	E2	=SUM(IFERROR(SUBSTITUTE(SUBSTITUTE(B2:D2,"Inc",2),"dec",1)+0,0))
Press CTRL+SHIFT+ENTER to enter array formulas.

 

[Fluff]

@DanteAmor
I have the advantage of being able to edit the OP & see the correct layout, it looks like

+Fluff New.xlsm
	A	B	C	D
1
2		inc	4sc	inc
3		dec	6sc
4		6sc	inc
Main

 

[DanteAmor]

Thanks Fluff, in that case it could be like this:

varios 08jun2020.xlsm
	A	B	C	D	E
1					Total
2		inc	4sc	inc	8
3		dec	6sc		7
4		6sc	inc		8
Hoja1

Cell Formulas
Range	Formula
E2:E4	E2	=SUM(IFERROR(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(B2:D2,"sc",""),"inc",2),"dec",1)+0,0))
Press CTRL+SHIFT+ENTER to enter array formulas.

 

[Tsclute]

Thank you. How to I assign the values to inc, dec?

 

[DanteAmor]

"inc",2),"dec",1

In that part of the formula.

 

[Tsclute]

One more question. When I applied the formula, it did not add #sc. In the first row, I get a total of 4 from the inc columns. How do I correct this?

 

[DanteAmor]

One more question. When I applied the formula, it did not add #sc. In the first row, I get a total of 4 from the inc columns. How do I correct this?

Maybe what does not add are the texts "inc", check that the texts are in lower case "inc" as they are in the formula.

 

[DanteAmor]

Or try this

varios 08jun2020.xlsm
	A	B	C	D	E
1					Total
2		INC	4sc	Inc	8
3		Dec	6sc		7
4		6sc	inc		8
Hoja1

Cell Formulas
Range	Formula
E2:E4	E2	=SUM(IFERROR(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(LOWER(B2:D2),"sc",""),"inc",2),"dec",1)+0,0))
Press CTRL+SHIFT+ENTER to enter array formulas.

 

[Tsclute]

Thank you so very much. That works perfectly!!