Sumproduct error value from another tab due to %

[JiteshNagar]

Hello,

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.

[#2]

@JiteshNagar 

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?