# When a cell is included in COUNTA _and_ COUNTBLANK "hit count"?

#### Jaymond Flurrie

##### Well-known Member
I have a 2x7 size cell area. =COUNTBLANK(TheAreaImTalkingAbout) returns as the answer 14, =COUNTA(TheAreaImTalkingAbout) returns 3 i.e. three of the cells are both. What's the key factor to make cell both "A" and "BLANK"?

If I activate the edit mode of the cell (doubleclick+Enter), it is blank. If I run "Clear Contents" for it, it is no more "A", just "BLANK".

### Excel Facts

Can Excel fill bagel flavors?
You can teach Excel a new custom list. Type the list in cells, File, Options, Advanced, Edit Custom Lists, Import, OK

#### XOR LX

##### Well-known Member
Hi.

I would hazard a guess that 3 of your cells in that range are not "genuine" blanks but contain e.g. the "" as a result of formulas in those cells.

Regards

#### Jaymond Flurrie

##### Well-known Member
Hi.

I would hazard a guess that 3 of your cells in that range are not "genuine" blanks but contain e.g. the "" as a result of formulas in those cells.

Regards

Doesn't this require that there are three cells that have formula in them? None of them does have a formula.

#### XOR LX

##### Well-known Member
The formulas could have been pasted over as values. Unless the actual cell contents are deleted, the "" will remain, although unseen of course.

Regards

#### pgc01

##### MrExcel MVP
What's the key factor to make cell both "A" and "BLANK"?

XOR Xl already answered, this is just another way to put it:

A cell both "A" and "BLANK" when it is type text and has no characters.

So, if

=ISTEXT(A1) is True
and
=LEN(A1) is zero

then the cell is both "A" and "BLANK"

Remark: the word blank is a bad word in excel. It is ambiguous.

#### XOR LX

##### Well-known Member
Remark: the word blank is a bad word in excel. It is ambiguous.

Indeed!

#### Jaymond Flurrie

##### Well-known Member
Thanks to both of you, this solves my problem!

#### pgc01

##### MrExcel MVP

Remember to run away from the word Blank. If instead of CountBlank() you were using IsBlank() then Blank would have another meaning.

Replies
9
Views
540
Replies
7
Views
2K
Replies
8
Views
2K
Replies
3
Views
3K
Replies
0
Views
520

1,195,651
Messages
6,010,932
Members
441,574
Latest member
Prescience

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back