Counting upper and lower case cell entries (Excel 2003)

[GillHarding]

Is it possible to count the number of upper and lowercase cell entries? See attached spreadsheet for example.

[HansV]

The following formulas are array formulas, i.e. they must be confirmed with Ctrl+Shift+Enter:

=SUM(1*EXACT(A1:A12,LOWER(A1:A12)))

=SUM(1*EXACT(A1:A12,UPPER(A1:A12)))

EXACT compares two strings, case-sensitive. The result is TRUE or FALSE. Multiplying by 1 forces this to be interpreted as numbers 1 and 0.

[GillHarding]

Thank you. Your help is much appreciated and you have saved me hours of work!