count the value of the drop down selections
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?
Best Answer
-
I found answer to question:
=SUM(VALUE(LEFT([field name]@row, 1))
Answers
-
I found answer to question:
=SUM(VALUE(LEFT([field name]@row, 1))
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.9K Get Help
- 429 Global Discussions
- 146 Industry Talk
- 486 Announcements
- 5.2K Ideas & Feature Requests
- 86 Brandfolder
- 151 Just for fun
- 74 Community Job Board
- 498 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!