Countif all value marked "1" in reference sheet
Options
hi!
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")
Answers
-
Hi @Jess N.
I think you are looking for something like this.
=COUNTIF({File 2}, "1")
I hope that helps.
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!