COUNTIFS #INVALID REF appear after a period of time

Options

Hello,



Able to get the countifs to total up some information in a different sheet.  But then after a period of time, some of the cells using the countifs display #INVALID REF when it worked when I created my sheet



screen shot shows a portion of my sheet,  all cells use countifs and all cells did count what I wanted it too.  What is triggering the cell to change to #INVALID REF

 

 

Capture.JPG

Tags:

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!