Thread: [Solved] Formula result not displaying in cell (but f9 works)
View Single Post
 
Old 10-05-2017, 04:47 AM
Debaser's Avatar
Debaser Debaser is offline Windows 7 64bit Office 2010 32bit
Competent Performer
  
Join Date: Oct 2015
Location: UK
Posts: 221
Debaser will become famous soon enough
Default
The problems are all caused by the circular references, which are actually on the W1 to W5 sheets, in rows 28:30 in all the machine columns. Your COUNTIF ranges include the cells that the formulas are in, which is what causes all the problems. Removing the formulas from those cells fixes everything, though you presumably need to actually correct the formulas!
Reply With Quote