Cap Sensitive Countif

T

Tod H

Is there a way to use the COUNTIF function in conjunction with a capital
sensitive criteria? In other words, I'd like to count cells that contain a
capital "X", and differentiate that from a count of small "x".
 
D

Duke Carey

This is an array formula which you enter by pressing ctrl-enter-shift

=SUMPRODUCT(--NOT(ISERROR(FIND("X",A7:A18))))
 

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

Excel Need Countifs Formula Help 0
countifs Function not giving desired result with date criteria 2
countif function: how to distinguish case/make case sensitive 3
CountIf previous cell formula 0
Count text then add results 2
Count the number of cells that conatin a "." in a range 5
If and Countif 2
If with countif or counta 3

Top