Hopefully I'll be able to explain clearly what I would like:
I have a spreadsheet about a car pool. I have to put an "x" (check) in a cell when there are seats available to transport people, but I want this "x" to have a value from another cell:
Hopefully I'll be able to explain clearly what I would like: I have a spreadsheet about a car pool. I have to put an "x" (check) in a cell when there are seats available to transport people, but I want this "x" to have a value from another cell: 


Try using this formula in
If you want count of those cells then use this formula:
If your sheet popup for Circular Reference, then you need to enable Circular Reference. Below are the steps:
Now you will result as 

