How do I count a specific word in a column?

Occasional Contributor

hello you Excel-lent people,  How do I count a specific word in a column?  Here, I would like to count the word 'Overdue' and have the total in C2




2 Replies

@Jella510 Perhaps like in the picture below:

Screenshot 2021-05-12 at 11.49.12.png


Alternative proposed solution

SUMIFS function



COUNTIFS applies criteria to cells across multiple ranges and counts the number of times all criteria are met. SUMIFS adds the cells in a range that meet multiple criteria.



Thank you for your patience and time.



I know I don't know anything (Socrates)