countif

  • Thread starter Thread starter Marion
  • Start date Start date
M

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
 
Try using counta() to get a total and then subtract the number of Fs and Ms.

HTH

Dave
 
Back
Top