Not much to explain here. It just does not work. You can see it works fine on Master Census Sheet, but not on Sheet1. All cells are in same format, and I have tried COUNTA with cells that contain text. Nothing works. I have to be missing something stupid here.
BADRED26desensitzed.xlsm