hi team

counta & countblank only works if the cell is cleared with 'clear
contents'. Rather then educate all the staff can I do something else?
The other issue is these cells are linked to another sheet.
how about count all the cells with strings between 4 & 10 in lenth as
the cells will contain patients names - thats what I wish to count.

how can I count cells based on them containing a text string of say
between 4 and 10 letters in lenght?

cheers