Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

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:

C:\fakepath\SumOfFormulatedRangeIssue.png

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

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

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. Any ideas?

C:\fakepath\SumOfFormulatedRangeIssue.png

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