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,...
Both formulae shall work if you'd like to count cells with one space " ". If to count cells with any number of spaces, e.g. " ", " ", etc
=COUNTIF(C3:C10000," *")If to count as well cells with empty strings "" and blank cells, when as suggested with SUMPRODUCT.