Using countif to see if any values are added

J

Jaydubs

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?
 
A

Andy Brown

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?
Click to expand...

=COUNTA(B3:B43)

Rgds,
Andy
 
Top