MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Counting Cells With Text

Posted by Kristoefu on January 14, 2002 5:19 PM

Does anyone have a formula to count the number of cells in a series that contain a given word?

I.E. count the number of cells between A1:A10 that contain the word "average"

Posted by Aladin Akyurek on January 14, 2002 5:23 PM

=COUNTIF(A1:A10,"average") [NT]