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

@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.