Excel counting blank spaces

  • Thread starter Thread starter rlampky
  • Start date Start date
R

rlampky

I have a column that contains letters and symbols. At the bottom of the
column I want to total only the blank spaces within that column. Any
suggestions?
 
=COUNTIF(A1:A100,"")

--
Best Regards
Leo Heuser
Excel MVP

Followup to newsgroup only please.
 
rlampky,

Just to make sure we're on the same page...

A B C -> 2 spaces
X Y -> 1 space
G H I J -> 3 spaces

Total = 6 spaces

=SUMPRODUCT(LEN(A1:A10) - LEN(SUBSTITUTE(A1:A10," ","")))

OR
-> 1 space
ABC
-> 1 space
XY
-> 1 space
-> 1 space
GHIJ

Total = 4 spaces

=COUNTIF(A1:A10,"")

Dan E
 
Back
Top