countif function: how to distinguish case/make case sensitive

[mvwoolner]

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?

 

[francis]

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

 

[Shane Devenshire]

Hi,

=SUMPRODUCT(--EXACT(A1:A4,"C"))

or

=SUMPRODUCT(--EXACT(A1:A4,B1))

where B1 contains C or c or whatever.

 

[Shane Devenshire]

Hi,

=SUMPRODUCT(--EXACT(A1:A4,"C"))

or

=SUMPRODUCT(--EXACT(A1:A4,B1))

where B1 contains C or c or whatever.