Answered You can hire a professional tutor to get the answer.
QUESTION
What is the formula for adding the second digit only in a column of numbers in excel?
What is the formula for adding the second digit only in a column of numbers in excel? For instance, if the numbers were:
100
140
196
The answer would be 13 (0+4+9). But I need the formula to add the second digit in a huge column of numbers. Thanks!
Number Second Digit Cumulative Sum1959912321123431445651956762587673223233533333822224012324212342442722751SUM- 9