Hi Paul,

It could be that the errant ones have been input as text instead of numbers,
or vice-versa.

Cheers


"Paulinmarketing" wrote in
message ...
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!!