countif function: how to distinguish case/make case sensitive

  • Thread starter Thread starter mvwoolner
  • Start date Start date
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?
 
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
 
Hi,

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

or

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

where B1 contains C or c or whatever.
 
Hi,

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

or

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

where B1 contains C or c or whatever.
 
Back
Top