How do I find out how many cell have a character writen in them?

[kiwi4444]

How do I find out how many cells have a character write in them?

Is there a formula for this?

Thank you.

Below is a picture of what I mean.

https://ibb.co/c8AhnJ

 

[jtakw]

Hi,

If you just want a Count of Column B, say B1:B100 that has Anything in it:

=COUNTA(B1:B100)

 

[kiwi4444]

Hi,

If you just want a Count of Column B, say B1:B100 that has Anything in it:

=COUNTA(B1:B100)

I can confirm that this does NOT work. I tried that on my computer and my fathers computer it didn't work.

Here is the picture.

So what do I do next?

 

[jtakw]

Don't see a picture, besides, it's better to post sample data and expected results.
Simply say "this does NOT work", don't tell us anything.

 

[Scott Huish]

I agree. That seems to do exactly as asked. Although if you need the whole column, just change the range to that:
=COUNTA(B:B)

Excel 2010
	A	B	C	D
1
2
3		e		17
4		e
5		e
6		e
7
8		ee
9
10		e
11		e
12		e
13		e
14		e
15		e
16		e
17		e
18		e
19		e
20		e
21		e
Sheet1

Cell Formulas
Range	Formula
D3	=COUNTA(B1:B100)

 

[kiwi4444]

Sorry I forgot to add the link.

https://ibb.co/msGf7J

I swear it doesn't work.

Why isn't it working does it work for other people?

 

[jtakw]

The formula uses COUNTA, not COUNT

=COUNTA(B1:B100)

 

[kiwi4444]

The formula uses COUNTA, not COUNT

=COUNTA(B1:B100)

HAHA ops thanks just noticed. :P

 

[jtakw]

You're welcome.