If you use a filter then you want to use the SUBTOTAL function. SUBTOTAL
will only calculate the visible rows.

=SUBTOTAL(3,A2:A100)

--
Biff
Microsoft Excel MVP


"Té" wrote in message
...
Is there a way to find repeated words in a spreadsheet, as well as how
many
times the word is repeated besides using the COUNTA function? I was
thinking
of filtering, and then applying the COUNTA function. Is that the easiest
way?