MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Formula to count occurrences


Posted by Jim on January 14, 2002 10:55 AM

If cells A1:A50 are either blank or have a one letter alpha character, what's the formula to count how many cells have the letter "L"?


Posted by Mark W. on January 14, 2002 11:01 AM

=COUNTIF(A1:A50,"L") (nt)