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

[rcsinsi]

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. 

[#2]

@rcsinsi 

Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?

[#3]

Hey. I'm having the same issue and it's driving me crazy. Any solution?

[#4]

I honestly gave up and made a new doc & transferred over the template/info. It made no sense at all.