When I set up a countif function relating to another sheet in a workbook,
most of the cells work but random one's don't and return a 0 even when the
source cells have the correct criteria.

I've checked the cell formatting and can't see why it doesn't work on random
cells

Help please!!