Hi,

The SUMPRODUCT in that cell is summing all values in L11:L36 for which the corresponding entry in B11:B36 is either blank or "Other". However, since cell B29 contains "GRAND TOTAL", the quantity in L29 (393.12) will be excluded from this summation, hence the discrepancy.

Regards