ROBJ
03-06-2018, 01:21 AM
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
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