Countif all value marked "1" in reference sheet


I'm trying to count the number of cells marked "1" from a reference sheet and return the value to Column 6. My current formula is as below but i'm getting 0 as return value which is incorrect. =COUNTIF({File 2}, @cell = "1")


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!