Hello,



I am working in a spreadsheet where I want to count how many cells start with "2011". My numbering is 8 digits (e.g., 20111234 where I want to capture those starting with 2011).

I have tried the following:
=COUNTIF(B2:B2154,"2011*"
but it returns a "0" as the result.

Any thoughts?

Perhaps Your formula looks for a string where XL sees a number

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

That worked!

Thanks so much!

To do it with countif:

__________________
Colin

RAD Excel Blog