Counting cells with text, ignoring spaces

[WBJ]

I want to count the number of cells that have text in an array in which cells appearing blank actually have spaces in them. COUNTA recognizes spaces as text.

Thanks for any ideas.

 

[Jon von der Heyden]

Hello

Try;
=COUNTA(A1:A10)-COUNTIF(A1:A10," ")

 

[fairwinds]

Hi,

Try:

=SUMPRODUCT(--(LEN(TRIM(A1:A10))>0))

 

[WBJ]

Both of these solutions work perfectly. Thank you.