Counting letters and symbols

Z

Zb Kornecki

Hi our schedule sheets now need to be encoded with a specific letter or
symbol for each possible shift. This include upper and lower case letters.
and most of the symbols on the key board. Will how do I get Countif it
differenciate an "A" form a "a". and will this work for symbols. thanks Zb
 
R

Ron Coderre

Try something like this:

For a list of values in A1:A1000

This formula counts the number of cells containng exactlly "A", versus "a":
=SUMPRODUCT(--EXACT(A1:A1000,"A"))

Does that help?
***********
Regards,
Ron

XL2002, WinXP
 
Top