How do I count a specific word in a column?

Copper 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

 

Jella510_0-1620810716629.png

 

2 Replies

@Jella510 Perhaps like in the picture below:

Screenshot 2021-05-12 at 11.49.12.png

@Jella510 

Alternative proposed solution

SUMIFS function

=SUMIF(C4:C12,"Overdue")

 

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.

 

Nikolino

I know I don't know anything (Socrates)