try this array formula, confirm by Ctrl,Shift and Enter

=SUM(IF(EXACT(A2:A5,"C"),1))
--
Hope this is helpful

Pls click the Yes button below if this post provide answer you have asked
An ordinary user helping another ordinary user and learn together

Thank You

cheers, francis



"mvwoolner" wrote:

Is there a way to make the countif function case sensitive? If cell A1 has a
'c' in it and cell a2 has a 'C' in it, how can I make =countif(A1:A2,'C')
give the value 1?