Use COUNTIF() to find the number of cells not equal to a blank space

**BNCOXUK** · 12-21-2012, 06:07 AM

Hi, I used the formula as:

=COUNTIF(A1:A1000, "<>" ""), but this resulted in a error.

Basically, in cells A1:A1000, some cells have one blank space" ".

**zbor** · 12-21-2012, 06:10 AM

So what are you trying to do? Count cells with one space?

use =COUNTIF(A1:A1000," ")

**BNCOXUK** · 12-21-2012, 06:39 AM

Originally Posted by zbor

So what are you trying to do? Count cells with one space?

use =COUNTIF(A1:A1000," ")

Sorry, actually count cells without one space

Most of the cells have proper strings, but some cells only have one spaces " "

**Pepe Le Mokko** · 12-21-2012, 06:11 AM

There is also a COUNTBLANK function available

**e.isayev** · 12-21-2012, 06:31 AM

Hi
Use COUANTA(A1:A1000)
Counts number of cells that are not empty

**Pepe Le Mokko** · 12-21-2012, 06:33 AM

Originally Posted by eisayew

Hi
Use COUANTA(A1:A1000)
Counts number of cells that are not empty

Slight typo, eisayew means COUNTA

**e.isayev** · 12-21-2012, 06:38 AM

Yes, I mean COUNTA()
Thank you Pepe Le Mokko
Sorry everybody

Use COUNTIF() to find the number of cells not equal to a blank space

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

Use COUNTIF() to find the number of cells not equal to a blank space

Re: Use COUNTIF() to find the number of cells not equal to a blank space

Re: Use COUNTIF() to find the number of cells not equal to a blank space

Re: Use COUNTIF() to find the number of cells not equal to a blank space

Re: Use COUNTIF() to find the number of cells not equal to a blank space

Re: Use COUNTIF() to find the number of cells not equal to a blank space

Re: Use COUNTIF() to find the number of cells not equal to a blank space

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions