countif function: how to distinguish case/make case sensitive
 

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?

countif function: how to distinguish case/make case sensitive
 

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?

countif function: how to distinguish case/make case sensitive
 

Hi,

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

or

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

where B1 contains C or c or whatever.


--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


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

countif function: how to distinguish case/make case sensitive
 

Hi,

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

or

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

where B1 contains C or c or whatever.
--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


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