Sumproduct error value from another tab due to %

Occasional Visitor



I've done a sumproduct formula, and it works fine, however when I do go over the row that has a percentage calculation it returns a #VALUE! error.


Anyway that I can bypass the error?


The formula is as below: -

=SUMPRODUCT(('T&C PL'!$B$5:$N$17)*('T&C PL'!$B$4:$N$4=Front!$F$15)*('T&C PL'!$A$5:$A$17='P&L'!$C45))


Where T&C PL is the tab reference


Thanks in advance.

1 Reply


Could you attach a sample workbook (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?