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

Formula not calculating in only one cell

Copper Contributor

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 dependents and it shows no differences. 

6 Replies

@LTJTYH 

Maybe there is a circular reference.

 

Thank you for your response.
I checked for a circular reference but it was not highlighted as an option to choose so I took that as not present.

@LTJTYH 

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?

@Hans Vogelaar 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.           

LTJTYH_0-1697652720218.png

Below: The formula from the above sheet

LTJTYH_1-1697652897031.png

Below: The sheet from which it is pulling the total to the first column (Bulk)above

LTJTYH_3-1697653131599.png

 

 

best response confirmed by LTJTYH (Copper Contributor)
Solution

@LTJTYH 

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.
1 best response

Accepted Solutions
best response confirmed by LTJTYH (Copper Contributor)
Solution

@LTJTYH 

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...

View solution in original post