If I want to count the number of cells with the text “EDC”, when the whole column has both that string alone, but also many cells with additional text (e.g.) “EDC thyroid”, what function do I use?
When I try: COUNTIFS(D1:D2001,(".EDC.")) it returns 0 or an err code. Searched for Libre help pages, but none of the simple suggestions I saw did anything…
=COUNTIF(D1:D2001;".*EDC.*")
The clue was in Countif for letter in middle of text. If your karma is >=5, can give an upvote there.
Tested with LibreOffice 6.3.6.2 (x86); OS: Windows 6.1.
Add Answer is reserved for solutions.
Press edit below your question if you want to add more information; also can comment an answer.
Check the mark (
) to the left of the answer that solves your question.
Muchisimas gracias, Leroy!
¡Fue un placer!
Si la respuesta solucionó tu inconveniente, no olvides marcar la tilde () que está a la izquierda.