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
1 Reply
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.
