Sum in a report shows zero for cells with value
Hello, I am building a report and inserting a basic sum recap, but the value shows as zero even if the cells targeted have data in it. Is it possible the problem comes from the fact that is is not a pure value but actually the result of a multiple IF formula ?
Here is a screenshot of the source in the sheet :
When I select the column, no sum or average are shown at the bottom, just a count :
And the intended report looks like this with zero as a SUM ("Somme" in French) :
I'm in a French display, sorry if it makes things a bit trickier.
Can you help me find a way to sum or average my data in the report recap option ? Thanks,
Help Article Resources
Check out the Formula Handbook template!