How do I count a specific word in a column?

Question

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

riny_van_eekelen · Answer

Jella510&nbsp;Perhaps like in the picture below:

nikolinode · Answer

Jella510&nbsp;Alternative proposed solutionSUMIFS function=SUMIF(C4:C12,"Overdue")&nbsp;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.&nbsp;&nbsp;Thank you for your patience and time.&nbsp;NikolinoI know I don't know anything (Socrates)&nbsp;

Forum Discussion

How do I count a specific word in a column?

2 Replies

Resources