Upper and Lower case in a Count

Originally Posted by CanMan12

I have macro that counts an "x" in a particular cell on multiple sheets and then reports it back on one sheet. It is all input manually by several users, so sometimes they use Upper case (X) and sometimes they use Lower case (x). How do I make Excel ignore the case and count if it is upper and/or lower case?

I think we need the macro to figure out the best choice.

Can you copy it here?

Thanks.