May 12 2021 02:14 AM
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
May 12 2021 02:50 AM
@Jella510 Perhaps like in the picture below:
May 12 2021 04:32 AM
Alternative proposed solution
=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)