Using countif to see if any values are added
 

Dear friends on MS,

I have a column in which I enter data. At the end of the column, I want to
see how many fields in the column do have data in them.
I was thinking of using =COUNTIF(B3:B43,"?"), but it gives me an entry of 0,
where I know data has been entered in some of the fields.

How should I tackle this?

--
** Fool on the hill **

"Jaydubs" wrote in message
...

I have a column in which I enter data. At the end of the column, I want to
see how many fields in the column do have data in them.
I was thinking of using =COUNTIF(B3:B43,"?"), but it gives me an entry of
0,
where I know data has been entered in some of the fields.
How should I tackle this?

=COUNTA(B3:B43)

Rgds,
Andy

Great,

This answers my question, Thanx mate !

"Andy Brown" wrote:

"Jaydubs" wrote in message
...

I have a column in which I enter data. At the end of the column, I want to
see how many fields in the column do have data in them.
I was thinking of using =COUNTIF(B3:B43,"?"), but it gives me an entry of
0,
where I know data has been entered in some of the fields.
How should I tackle this?

=COUNTA(B3:B43)

Rgds,
Andy