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" <[email protected]> wrote in message
news:[email protected]...

> 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" <[email protected]> wrote in message
> news:[email protected]...
>
> > 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
>
>
>