Hi All
I have an issue with a SUMPRODUCT formula I have used.
=SUMPRODUCT(('Feed Data'!A$79:A$128='Running Report Sept Onwards'!H123)*('Feed Data'!B$79:B$128='Running Report Sept Onwards'!J123)*('Feed Data'!D$79:D$128='Running Report Sept Onwards'!E123)*('Feed Data'!E$79:E$128='Running Report Sept Onwards'!N123)*('Feed Data'!F$79:F$128))
The formula is looking for essentially a sales price based on 4 other bits of information, the formula is picking up 90% of the values required but missing some in particular, no obvious reason.
Can anybody assist, any obvious errors?
Best
Sam
I have an issue with a SUMPRODUCT formula I have used.
=SUMPRODUCT(('Feed Data'!A$79:A$128='Running Report Sept Onwards'!H123)*('Feed Data'!B$79:B$128='Running Report Sept Onwards'!J123)*('Feed Data'!D$79:D$128='Running Report Sept Onwards'!E123)*('Feed Data'!E$79:E$128='Running Report Sept Onwards'!N123)*('Feed Data'!F$79:F$128))
The formula is looking for essentially a sales price based on 4 other bits of information, the formula is picking up 90% of the values required but missing some in particular, no obvious reason.
Can anybody assist, any obvious errors?
Best
Sam