Excel counting blank spaces

[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?

 

[Leo Heuser]

=COUNTIF(A1:A100,"")

--
Best Regards
Leo Heuser
Excel MVP

Followup to newsgroup only please.

 

[Dan E]

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