How to find the digital sum (also know as the digital root) of a set of numbers in Microsoft Excel
The general formula "=1+mod(A1-1,9)" is able to determine the digital sum of any number. The mechanics behind this formula and why it works is explained in this video.
#digitalsum #excel