Google Spreadsheet How to use both text and function

Question:

( by GoogleRookie2013 )

I am trying to create a google spreadsheet that allows me to 

1. Have a drop down with both numeric value and text (for justification of numeric value only).

2. Compute a final score only using the numeric value assigned during the drop down.

I am currently using google docs via google chrome on both a PC and MAC, and so far every attempt to make this happen has resulted in failure. 

Thank you in advance for any assistance that you can provide.

Sincerely,

Dave

Solution:

Have a look at the following screenshot:

I have the following formula in Cell Q4:

=100+sum( iferror(value(regexextract(text(A4;"");"[-0-9]{1,}"))) ; arrayformula(iferror(value(regexextract(text(C4:P4;"");"[-0-9]{1,}")))) )

I hope the above solution will help you, and if you need more help then please do comment below on this blog itself, I will try to help you out.

I also take up private and confidential projects:

http://igoogledrive.blogspot.com/p/paid-projects.html

If this blog post was helpful to you, and if you think you want to help me too and make my this blog survive then please donate here: http://igoogledrive.blogspot.com/2012/09/donate.html 

Thanks,

Kishan.

iGoogleDrive