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 ...
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
