yogi_From A Composite List Of Entities Count Entities Considering Case Sensitivity

Google Spreadsheet   Post  #2104

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Jan-06-2017

question by: ASchwab:

https://productforums.google.com/forum/?visit_id=1-636193431124668080-3096751358&rd=1#!topic/docs/PWBgW9TKCp0;context-place=forum/docs

Counting capitals versus lowercase letters?

I have cells with the following items in it:

(c)

(b, B)

(c, b)

(cc, bb, b)

etc.

Basically, all combos of c's, b's, and k's in parenthesis. Some are capital letters, some are double letters.

Each set is in it's own cell.

Now, I am trying to get a count of these.  Basically, something like:

b = ##

c = ##

bb = ##

B = ##

C = ##

I can get it for the double letters, and single letters.  But, now I cannot get it to differentiate between capital letters and lowercase letters on the countif function.

Is there a way to get it to ONLY count if there is a capital letter and ONLY count if there is a lowercase letter