Countif all value marked "1" in reference sheet

Jessintha Nathan

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")

Matt Johnson

Hi @Jess N.

I think you are looking for something like this.

=COUNTIF({File 2}, "1")

I hope that helps.