Copilot for Microsoft 365 Tech Accelerator
Feb 28 2024 07:00 AM - Feb 29 2024 10:30 AM (PST)
Microsoft Tech Community

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

Copper Contributor

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. 

3 Replies


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?

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

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