Excel - Count all non-blank cells, excluding empty string

Question

If I use COUNTA(range), it counts cells with the empty string (""). How do I avoid this? COUNTIFS(range,"<>"&"") doesn't seem to work.

Answer 1

For column A, cells A1 through A100 try:

=SUMPRODUCT(--(A1:A100<>""))