With regards to the formulas’ breakdown when inputting values in the TTM, that shouldn’t be happening. Make sure you are only inputting numbers in the cells with blue text and that if you are copying the numbers in from another spreadsheet, they are true numbers and don’t have any spaces or anything that may have excel not recognize it as a number. Other than that, I’m not sure what could be the issue here.