Also if you just wanted a count of all the lowercase letters regardless of
what they are, then assuming no blanks
=SUMPRODUCT(--(CODE(A1:L100)=97))
--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03
----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------
"Sivsy" wrote in message
...
Is there a way to distinguish between and count the occurance of lower and
upper case letters in an array ? eg If I have a series of columns
populated
with either uppercase "S" or loercase "s", can i use a formula to count
the
occurance of each type ?
|