SOLVED

# Counting data without specific text

Copper Contributor

# Counting data without specific text

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 Replies
best response confirmed by Mandie_A (Copper Contributor)
Solution

# Re: Counting data without specific text

You could use

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

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

# Re: Counting data without specific text

Thank you this has worked. Apologies for the small screenshot
1 best response

Accepted Solutions
best response confirmed by Mandie_A (Copper Contributor)
Solution

# Re: Counting data without specific text

You could use

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

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