### SUM OF FORMULATED RANGE NOT WORKING

I am trying to sum a range where each cell in the range is the result of a formula, but for some reason it doesn't work, the sum is always zero. I have created a simplified reproducible case. See attached image and spreadsheet demonstrating the ~~problem:~~problem. Any ideas?

C:\fakepath\SumOfFormulatedRangeIssue.png

C:\fakepath\SUM OF FORMULATED RANGE PROBLEM.ods