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

For column A, cells A1 through A100 try:

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