countif

[Marion]

I have used the countif function to count cells in one
column which have M within them and another function that
counts cells (in the same column) that have F within
them. To ensure that there are no rogue entries I would
to use countif to count the number of cells that do not
have either M or F within them. I can not seem to get it
work looking at both criteria. Any help would be
gratefully received.

Many thanks

 

[Dave Smith]

Try using counta() to get a total and then subtract the number of Fs and Ms.

HTH

Dave

 

[ivano]

I think:
=MIN(COUNTIF(A1:A10,"<>"&{"m","f"}))
try...
..i