Microsoft Office Forums - View Single Post - Countif

Thread: Countif

View Single Post

Old

01-04-2013, 12:00 PM

hockeytown hockeytown is offline

hockeytown is offline

hockeytown uses Windows 2K

Windows 2K hockeytown uses Office 2010 64bit

hockeytown uses Office 2010 64bit

Office 2010 64bit

Novice

The original poster

Join Date: Aug 2012

Posts: 12

hockeytown is on a distinguished road

Default

Countif

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?

Reply With Quote