Add Numbers with text in row

[IKHAN]

Hello,

Need assistance in adding numbers with text in a row ,Total needs to be updated dynamically as numbers change in row.

Have drop downs in cells to select V 1.0 or S 1.0,S 0.25, S 0.5 list

ex :

Row 4 : V 1.0 v 0.25 D 0.25 D 1.0

output reqd. Row 5 under P column 1.25 under S Column 0.75

Attached sample file

 

[xlstime]

Hey Ikhan,

Use below array formula with crt+shft+enter
cell p15 =

=SUM(IFERROR(SEARCH(P$14,$B15:$O15),0)*--IFERROR(RIGHT($B15:$O15,LEN($B15:$O15)-1),0))

Hello,

Need assistance in adding numbers with text in a row ,Total needs to be updated dynamically as numbers change in row.

Have drop downs in cells to select V 1.0 or S 1.0,S 0.25, S 0.5 list

ex :

Row 4 : V 1.0 v 0.25 D 0.25 D 1.0

output reqd. Row 5 under P column 1.25 under S Column 0.75

Attached sample file

 

[IKHAN]

Pasted above code in P15 by ctrl shift enter.. Doesnt Work .. Shows as 0.00

 

[xlstime]

File uploaded, please check

Pasted above code in P15 by ctrl shift enter.. Doesnt Work .. Shows as 0.00

 

[IKHAN]

Thanks xlstime ...It works.

What was changed in the code , Coz if i copy code into exact another spreadsheet. It doesnt work.

 

[shrivallabha]

Following formula also works with normal (non-CSE) entry. Put in P4 and copy down and across:
=SUMPRODUCT(MID($B4:$O4&"000",3,4)*ISNUMBER(SEARCH(P$3,$B4:$O4)))

 

[IKHAN]

Thanks @shrivallabha and @xlstime

 

[xlstime]

Nothing, Just shared the workbook

Thanks xlstime ...It works.

What was changed in the code , Coz if i copy code into exact another spreadsheet. It doesnt work.