countif function: how to distinguish case/make case sensitive

M

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?
 
F

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
 
S

Shane Devenshire

Hi,

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

or

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

where B1 contains C or c or whatever.
 
S

Shane Devenshire

Hi,

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

or

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

where B1 contains C or c or whatever.
 
Top