-
SUMPRODUCT formula does not add up negative numbers.
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules