Forum Discussion
LTJTYH
Oct 18, 2023Copper Contributor
Formula not calculating in only one cell
I have one row on one sheet in my workbook not calculating. The formula is correct above and below the row. I have checked the calculation options and they are set to auto. Trace precedents and dep...
- Oct 18, 2023
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...
LTJTYH
Oct 18, 2023Copper Contributor
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
HansVogelaar
Oct 18, 2023MVP
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...
- LTJTYHOct 18, 2023Copper ContributorThank you! That was it. I thought I had retyped it but I evidently had not.