Help w/adding up formula totals
Hi team  I created a test sheet that I'm experimenting with various drop down menus creating scores. The drop down to score is working fine, where I have a problem is getting the "Total score" column to add all 5 scores.
What am I missing?
Total score formula:
=VALUE([Impact score]@row + VALUE([SLO score]@row + VALUE([Short term resilency score]@row + VALUE([Risk score]@row + VALUE([Sub contract dependency score]@row + VALUE([Long term resiliency score]@row))))))
Thanks for any assistance you can provide.
Best Answer

Hi @jmoser
Your scores are obsiously string text and not numbers from the screenshot you provided. You should try to correct that.
Also, you have the parenthesis wrong on your formula. It should be like this:
=VALUE([Impact score]@row) + VALUE([SLO score]@row) + VALUE([Short term resilency score]@row) + VALUE([Risk score]@row) + VALUE([Sub contract dependency score]@row) + VALUE([Long term resiliency score]@row)
Another way to do it would be:
=SUM(VALUE([Impact score]@row), VALUE([SLO score]@row), VALUE([Short term resilency score]@row) VALUE([Risk score]@row), VALUE([Sub contract dependency score]@row), VALUE([Long term resiliency score]@row))
Hope it helped!
Answers

Hi @jmoser
Your scores are obsiously string text and not numbers from the screenshot you provided. You should try to correct that.
Also, you have the parenthesis wrong on your formula. It should be like this:
=VALUE([Impact score]@row) + VALUE([SLO score]@row) + VALUE([Short term resilency score]@row) + VALUE([Risk score]@row) + VALUE([Sub contract dependency score]@row) + VALUE([Long term resiliency score]@row)
Another way to do it would be:
=SUM(VALUE([Impact score]@row), VALUE([SLO score]@row), VALUE([Short term resilency score]@row) VALUE([Risk score]@row), VALUE([Sub contract dependency score]@row), VALUE([Long term resiliency score]@row))
Hope it helped!

Hi @David Joyeuse  you helped me immensely!
This one worked: =SUM(VALUE([Impact score]@row), VALUE([SLO score]@row), VALUE([Short term resilency score]@row) VALUE([Risk score]@row), VALUE([Sub contract dependency score]@row), VALUE([Long term resiliency score]@row))
Truly appreciate your timely response.
Jeff

The numbers may not necessarily be text values. It would depend on how they are populated. Numbers that are center justified do not denote text vs numbers.
Numbers are right justified and text is left justified except in the Primary Column where all values are left justified.
Of course this is all dependent on no formatting being applied to the column.
If your scores are in fact numbers, then you could actually drop the VALUE functions which would save you a little bit of typing, less parenthesis to fight with, and would be a little more efficient on the backend of things.
But with them being centered in the column there is no way to tell just by your screenshot whether they are text or numerical values.
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 10.9K Get Help
 65 Global Discussions
 69 Industry Talk
 385 Announcements
 3.6K Ideas & Feature Requests
 56 Brandfolder
 125 Just for fun
 50 Community Job Board
 464 Show & Tell
 40 Member Spotlight
 44 Power Your Process
 28 Sponsor X
 234 Events
 7.3K Forum Archives
Check out the Formula Handbook template!