count the value of the drop down selections

Richard Zombek

in a sheet I 3 separate fields that have values associated with the drop down selection:

Example:

Column Headings: Sales Prep Sales Presentation

0 - not prepared 0 - Rep did not show

1 - Basic info 1 - Good presentation

2 - Well prepared 2. Excellent

now I want to count the selection in a total Demo Score field

Example:

Sales Rep Name Sales Prep Sales Presentation Demo Score

John Q Public 2- Well prepared 1- Good Presentation 3

Question

How can I sum up the drop down values, 2+1 = 3?

Richard Zombek

I found answer to question:

=SUM(VALUE(LEFT([field name]@row, 1))

Richard Zombek

I found answer to question:

=SUM(VALUE(LEFT([field name]@row, 1))