My CountIf function is straight just not working, and I'm curious what I've done wrong. It only seems to output 1 or 0, and bizarrely is doing so differently depending on where in the sheet I put the data.
What's going on with this?
Super User is a question and answer site for computer enthusiasts and power users. It only takes a minute to sign up.Sign up to join this community
You could also use a CSE formula (CSE means you have to press CTRL+SHIFT+ENTER instead of just ENTER):
This also counts blank cells when compared to other blank cells, so it might not be what you want.
Update: I'd like to include Bandersnatch's solution that separately counts the blanks and subtracts them from the total: