COUNTIF

[deemer98]

Good morning all,

I think I need to use COUNTIF, but could be wrong.

First of all, can I use COUNTIF if there are blank cells? I want it to count an entry for F:F, but I will only populate about 30 rows reach day.

COUNTIF(F2:F21,"105") works great now, but if I put F:F, I get 0 for the answer. Also, my other option for that column will be "ML5221", but I can't get it to count at all. Any thoughts?

Thanks!

David

 

[deemer98]

Well, I got F:F for the 105's to work, but still getting a 0 for the ML5221

 

[shaowu459]

Will you please upload a snapshot of your data in column F?

 

[Joe4]

but still getting a 0 for the ML5221

Manually locate a cell with "ML5221" in it. Let's say it is cell F18.
Then in any blank cell on your sheet, enter thos formula and see what it returns:
=LEN(F18)

If that returns anything other than 6, then you have extra characters in those entries that need to be accounted for.
If it does return 6, please post the exact COUNTIF formula you are trying.

 

[deemer98]

Got it. There were extra characters after the ML5221. Must have just been spaces because there was nothing to see. Thanks!

 

[Joe4]

There were extra characters after the ML5221. Must have just been spaces because there was nothing to see. Thanks!

You are welcome.
Yes, that is not uncommon in data that comes from other sources, or Web scrapes.