COUNTIF counts cells matching a condition; use wildcards to count cells containing a word.
Do it with AI insteadCount all text cells
Use =COUNTIF(A2:A100, "*") — the asterisk matches any text.
Count a specific word
Use =COUNTIF(A2:A100, "*paid*") to count cells containing "paid".
Count with multiple conditions
Switch to COUNTIFS to add more criteria.
=COUNTIF(A2:A100, "*paid*")Use COUNTA(range), which counts everything that isn't empty.