Sumproduct error value from another tab due to %

Occasional Visitor

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.

1 Reply

@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?