Countif all value marked "1" in reference sheet

Countif all value marked "1" in reference sheet

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

Sign In or Register to comment.