Excel count cells

Occasional Visitor

Hello i want to count how many cells have all capital letters, if one text have one only small letter no count, only count the cell with all capital letter

1 Reply


Lets say you want to do this for A2:A50.

If you want to include empty cells in the count:




If you want to exclude empty cells:




If you don't have Microsoft 365 or Office 2021, you may have to confirm the formula with Ctrl+Shift+Enter.