Yes, you can use the combination of

Formula:

COUNTIF 


and

Formula:

NOT 


functions to count all text values except a certain one (in this case, 'ditto'). Here are the steps:

1. Select an empty cell where you want to display the count result.
2. Type the following formula:
   Formula:

   =COUNTIF(range,"<ditto") 

   - Replace "range" with the range of cells that contains the text values you want to count (e.g. A1:A10).
   - The "<" symbol means "not equal to", so the formula will count all cells that do not contain the word "ditto".
3. Press Enter to apply the formula.

The result will be the count of all text values in the specified range that are not equal to "ditto".