Forum Discussion
Counting cells containing spaces
I'm trying to count a column of cells which contain a string of numbers, dashes and spaces. I would like to count the cells which only contain spaces. I've tried: =COUNTIFS(C3:C10000,"*",C3:C10000,...
maybe
=SUMPRODUCT(--(TRIM(C3:C10000)=""))
or if you need to exclude emply cells try:
=SUMPRODUCT((C3:C10000<>"")*(TRIM(C3:C10000)=""))