Need help with a SUM/LEFT formula
I need a formula that will add the 1st number in different cells in a row.
So in the below picture, there will be different numbers in these cells, with text behind it. At the end of the row I would like to add all these numbers together and get an overall score.
Here is the SUM formula I have, just need to know how to pull in the left function to pull in the number at the beginning.
=SUM([1. Accuracy of product ordered]@row, [2. Condition of product and packaging]@row, [3. Product arriving on the anticipated day]@row, [4. Effectiveness of Help Desk support]@row, [5. Communication from Primary Hub]@row, [6. Accuracy of product ordered.]@row, [7. Condition of product and packaging]@row, [8. Product arriving on the anticipated day.]@row, [9. Effectiveness of Help Desk support.]@row, [10. Truck Arrive at anticipated time]@row, [11. Communication from Traffic Department]@row, [12. Staging of product upon delivery]@row, [13. Open communication with your hub/driver]@row, [14. Will Call program accuracy and process]@row, [15. Level of satisfaction with 3rd party carriers]@row)
Best Answer

You'll need to restructure your formula to follow this pattern:
=SUM(VALUE(LEFT([1. Accuracy of product ordered]@row, 1)) + VALUE(LEFT([2. Condition of product and packaging]@row, 1)))
Hope this helps!
Answers

You'll need to restructure your formula to follow this pattern:
=SUM(VALUE(LEFT([1. Accuracy of product ordered]@row, 1)) + VALUE(LEFT([2. Condition of product and packaging]@row, 1)))
Hope this helps!
Help Article Resources
Categories
Check out the Formula Handbook template!