 # Get instant live expert help on sum of the years digits formula “My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

## Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

## Here are some problems that our users have asked and received explanations on

How do you replace the sum of formula with its resulting digits. ie replace =SUM(J21:AC21) with 76
Solved by B. B. in 26 mins
i need data to be enter automatically in a cell of another excel document and i dont save the digits that i enter in the document but the digits remain in the other excel and as many times i enter the differet digits that digits are coming in the same cell of other document and theri sum comes into the next cell
Solved by F. F. in 27 mins
i need to copy this formula across the column =sum(W4:W5)/S4, however the number of digits in the W column keep increasing as you scroll down. For instance, my formula for the next set of data would be =sum(W13:15)/S13. How do i do this?
Solved by F. S. in 17 mins
Need help with setting up Straight Line Depreciation, Double Declining Balance, and Sum of Year Digits in excel
Solved by K. L. in 23 mins
I need a chart Y Axis --> Sum of total Commitment Amount X Axis --> Years
Solved by O. A. in 20 mins