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

Occasional Visitor

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 should, however, V and on have the correct formula listed for their respected columns but will not properly calculate. I tried to click and drag the formula from P to W (or anything after U) it will correctly populate for P to U but then just paste/copy the same number for the remaining columns.