coliervile
Well-known Member
- Joined
- May 19, 2006
- Messages
- 724
Can the COUTNIF function count small letters and Capital letters. For example A1:A50 contains the letters (random) L, l, T, n, W, a, A, F, E, a, e..... and so on what formula would be used to count all of the Small -a-
=Countif(A1:A50,"a") would count all of the a's
Regards
Charlie
=Countif(A1:A50,"a") would count all of the a's
Regards
Charlie