Sep 01 2022 07:37 AM
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.
Sep 01 2022 11:36 AM
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?