Excel count cells

[Stan2003]

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

[#2]

@Stan2003 

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.