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

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

"Tod H" wrote:

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