Forum Discussion
laws120
Feb 24, 2025Copper Contributor
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,...
HansVogelaar
Feb 24, 2025MVP
Does this do what you want?
=SUM(--(TRIM(C3:C10000)=""))