Formula is working in one cell but not another when the formulas are the same

I have had this happen a few times. The sumproduct formula works correctly in some columns but will not work in the others even though the formulas match. So, for columns P through U work as they sho...