CODEWITHSUNDEEP
excelexcel-formula
Simon GIS
Simon GIS

Reputation: 1055

Excel Count not blanks cells of different format

I have some excel columns with different format.

Some are blanks and returns me "1" has a result. How possible?

I have been trying to have a standardize formula. Which dint work out.

=COUNTIF(BG:BG,"<>")
=COUNT(BF2:BF)
=COUNT(BF:BF)
=COUNTA(BF:BF)

Whats the proper formula to count all NOT BLANKS cells in a column?

Upvotes: 0

Views: 49

Answers (2)

LizbethEll
LizbethEll

Reputation: 86

What is the data? I would assume you have some cells with spaces in them. If you are counting cells with numbers you could try;

=Countif(BF:BF,">"&1)

If they have words in them, try doing a trim function making a new reference column? =trim(BF2) and drop the formula down. Sorry its the best I can think of.

Upvotes: 0

Dominique
Dominique

Reputation: 17527

What about using the IsBlank() function? Something like (not tested):

=SUM(If(IsBlank(BF:BF);0;1))

Upvotes: 1

Related Questions