MrExcel Publishing
Your One Stop for Excel Tips & Solutions

What formula do I need please?


Posted by Tim on October 17, 2001 4:41 AM

In Excel, what formula do I need to find out how many times the text "John" appears in the column?
John
Peter
Tony
John
Peter
Simon
John


Posted by George on October 17, 2001 4:52 AM


Use Countif.
Range: {Select the cells the names will appear in}
Criteria: John
The cell you put this formula into will say 3

George