Monday, September 2, 2013

Google Spreadsheet How to use both text and function


( 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.



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:
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: 


No comments:

Post a Comment