Forum Discussion
Solved
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?
You could use
=COUNTA(F:F)-SUM(K24:K30)
(I hope I got the range right, your screenshot is very small)
You could use
=COUNTA(F:F)-SUM(K24:K30)
(I hope I got the range right, your screenshot is very small)
- Thank you this has worked. Apologies for the small screenshot
