Cannot calculate the sum when using if condition

[edigonzales]

Hi

I have a template with an if condition (see screenshot). I'm not able to calculate the sum of the values of one column. The sum row is not rendered at all. Is there something wrong with my expressions? It works without the if condition.

[SoltauFintel]

Try this: jx:area lastCell="C4"
jx:each lastCell="C3"
SUM over C2:C3

[edigonzales]

Thanks. I got a sum right now but the sum respects only the rows < 1000.