modified COUNTIF

J

Jack Zhong

Generally COUNTIF would ignore the case of the text, but I would like
to count the text on a case sensitive base. Suppose in Cell A1 contains
"jack", and in Column B contains "Jack", "JACK", "jACK" and "jack", I
want to know what formula could count the number of "jack" in Column B?

Thanks.

Jack
 
L

Leo Heuser

Jack Zhong said:
Generally COUNTIF would ignore the case of the text, but I would like to
count the text on a case sensitive base. Suppose in Cell A1 contains
"jack", and in Column B contains "Jack", "JACK", "jACK" and "jack", I want
to know what formula could count the number of "jack" in Column B?

Thanks.

Jack
Click to expand...
Hi Jack

One way:

=SUMPRODUCT(EXACT(A1,B1:B4)+0)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

counting formula 3
Dcount or Countif? 2
How to search and replace cells 0
count if two values are true 4
CountIf or another function 4
Counting text 2
sumproduct function with text?? 9
Can I select cells 3 columns away from a value in a line 3

Top