Counting data without specific text

[Mandie_A]

Hi

I am trying to count reasons for leaving in a spreadsheet, I can count specific text but I want to try and count anything that I dont specify.  Is this possible?

I have used the following for specific text:

=COUNTIFS(F:F,"New Job")

=COUNTIFS(F:F,"Retirement")

=COUNTIFS(F:F,"End of Contract")

But I want to count anything that doesnt fit these criteria as other, how can this be done?

[#2 · Accepted solution]

@Mandie_A 

You could use

=COUNTA(F:F)-SUM(K24:K30)

(I hope I got the range right, your screenshot is very small)

[#3]

Thank you this has worked. Apologies for the small screenshot