Using countif to see if any values are added

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Need Countifs Formula Help 0
Excel Help to copy information from one row at a time to another sheet 1
countif with multiple criteria 5
Sorting and COUNTIF 6
Sumproduct or countif or both... 3
Excel Dragging countif formula with changing criteria 3
Incremental time values based upon clock in and clock out times 8
COUNTIF, Sorting, on Two Sheets 1

Back
Top