Forum Discussion
Formula not calculating in only one cell
Check carefully that the spelling is exactly the same - perhaps you have "Yellow Corn Raw" on one sheet and "Yellow Corn Raw " (with an extra space) on the other...
I checked for a circular reference but it was not highlighted as an option to choose so I took that as not present.
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?
HansVogelaar See below. Not sure if the photos will help but below are some shots.
Below: Yellow Corn Raw is 0 and should be calculating from a different sheet. The first two columns are pulling from two other sheets. The 3rd is the total of the first two columns.
Below: The formula from the above sheet
Below: The sheet from which it is pulling the total to the first column (Bulk)above
Check carefully that the spelling is exactly the same - perhaps you have "Yellow Corn Raw" on one sheet and "Yellow Corn Raw " (with an extra space) on the other...
- Thank you! That was it. I thought I had retyped it but I evidently had not.