View Single Post
  #1   Report Post  
Jaydubs
 
Posts: n/a
Default 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 **