Forum Discussion
Excel count cells
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
Lets say you want to do this for A2:A50.
If you want to include empty cells in the count:
=SUMPRODUCT(--EXACT(A2:A50,UPPER(A2:A50)))
If you want to exclude empty cells:
=SUMPRODUCT((A2:A50<>"")*EXACT(A2:A50,UPPER(A2:A50)))
If you don't have Microsoft 365 or Office 2021, you may have to confirm the formula with Ctrl+Shift+Enter.