CODEWITHSUNDEEP
excel
dashnick
dashnick

Reputation: 2060

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

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

Upvotes: 9

Views: 4723

Answers (1)

Gary&#39;s Student
Gary&#39;s Student

Reputation: 96753

For column A, cells A1 through A100 try:

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

Upvotes: 5

Related Questions