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)
