View Single Post
  #2   Report Post  
Andy Brown
 
Posts: n/a
Default

"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