I am trying to build an advanced formula field that will calculate a total from some pick list fields I have on my lead page in a sandbox, I have 4 controlling pick list fields with 6 possible choices in each and each of them has a dependent pick list field with a scale of 5 - 0 points that defaults based on the choice in the controlling field associated with it.  The associated dependent pick list field is the one I need to use to add together to get the total.  Any help would be appreciated.

NameType                                         
Capability Match with Needs (Controlling)            
Capability Match Likert scale (Dependent)             
Timeline/Pricing Likert scale   (Dependent)           
Timeline/Pricing Expectations (Controlling)             
Clarity of request Likert scale  (Dependent)            
Clarity of Request  (Controlling)                           
Funding Info Likert Scale (Dependent)                   
Funding Information  (Controlling)                          

I am trying to build an advanced formula field that will calculate a total from some pick list fields I have on my lead page in a sandbox, I have 4 controlling pick list fields with 6 possible choices in each and each of them has a dependent pick list field with a scale of 5 - 0 points that defaults based on the choice in the controlling field associated with it.  The associated dependent pick list field is the one I need to use to add together to get the total.  Any help would be appreciated.

NameType                                         
Capability Match with Needs (Controlling)            
Capability Match Likert scale (Dependent)             
Timeline/Pricing Likert scale   (Dependent)           
Timeline/Pricing Expectations (Controlling)             
Clarity of request Likert scale  (Dependent)            
Clarity of Request  (Controlling)                           
Funding Info Likert Scale (Dependent)                   
Funding Information  (Controlling)