Hello there

The below formula which sums up the data in cell C16 acrossvariable number of worksheets seems to ignore negative numbers.Any solution would be greatly appreciated


=SUMPRODUCT(SUMIF(INDIRECT("'"&INDEX($T$5:$T$204,MATCH($N$3,$T$5:$T$204,0)) :INDEX($T$5:$T$204,MATCH($O$3,$T$5:$T$204,0))&"'!C16:C16"),">0"))

Thank you in advance