Countif with upper and lower case

[Dave Davis]

I have a range of cells in a column, each cell only
contains one letter. I am trying to do a countif to
determine how many instances of the particular letter
occur but I need to differentiate between upper case and
lower case letters. I had hoped this would work, =COUNTIF
(C2:C383,UPPER("S")) but it doesn't - it still counts the
lower case characters too :-( I did wonder about using
the CODE function to establish the value of eah character,
but it starts to get busy... Any suggestions please?

 

[Andy B]

Hi

Try using the EXACT function.

 

[Leo Heuser]

Dave

One way:

=SUMPRODUCT(EXACT(C2:C383;"S")+0)

 

[Leo Heuser]

Comma instead of semicolon. Sorry:

=SUMPRODUCT(EXACT(C2:C383,"S")+0)

LeoH